SUMMARY

• Over Fifteen yearsof diversified IT experience with expertise as anOracle DBA,providing production support and development for large, mission - critical Oracle RDBMS environments sized Confidential 27 TB and comprised of 14 RAC nodes.
• Support included data replication via Oracle Golden Gate and front-end database access via Oracle HTTP Server and Web Cache. Additional experience and background in software development.
• Spanning management, analysis, design, documenting, functional specification, feasibility study, development, testing and implementation of various systems under Unix, Windows NT environments forTelecommunication, Financial institutes and Entertainment Companies with deep insight into SDLC.

TECHNICAL SKILLS:

Languages: ASP, Perl, Java, C, C++, PL/SQL, SQL, Transact SQL,Java Scripts, JDBC, Pro *C, Shell, XML

Tools: GoldenGate Replication, Informatica Tool, Oracle Enterprise Manager (OEM), RMAN, Oracle Advanced Queuing, Quest Toad 7.x, SQL Navigator 3.2d11, Crystal Reports 4.0/7.0, Visual Source Safe 6.0, Visual InterDev 6.0. Developer/2000, Designer, Cold Fusion 4.0, Visual Java ++ 1.1, FrontPage. Connect Direct, Harvest

Databases: Oracle 11g/10g/ 9i / 8.x / 7.x, MS SQL Server 6.5/ 7.0/2000/2005, MS Access.

Application/Web Server: BEA Weblogic 8.x,9.x, iplanet

Unix Admin: Shell Scripting Unix Admin, Firewall Issues

Design: Data Modeling, Logical & Physical Design, Data Mart, Erwin

Operating Systems: IBM AIX 5.2/5.3, Sun Solaris 9/10, Windows NT, 2000

Harare: IBM PCs and compatibles, Compaq NT Server.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Sr. Oracle DBA

Responsibilities:

• Performed installation, configuration, deployment, migration and up gradation of various systems and database servers of 11g, 10g and 9i.
• Performed system design, database, schema design, and data modeling for development projects.
• Implemented security standards, plans and change management policy (SOX) for uses in development/production system.
• Patch maintenance and monitoring.
• Oracle Database Replication Golden Gate Replication
• Oracle HTTP/WEBCACHE server configuration (Oracle Fusion Middleware) and maintenance for mobility DME2 cloud services.
• Support large number of replication between multiple databases.
• Configured and support Informatica data transformation tool.
• Developed strategies for disaster recovery, backup using RMAN and Datapump, testing, verification & validation, data cleansing.
• Involved in performance fine-tuning of teh queries, stored procedures and materialized views using tool like stats pack, explain plan, sql trace and tkprof and oracles functions like rollup, cube and indexing schemes, process modifications.
• Administration of User accounts, Monitoring and maintenance of existing server environment.
• Handled transaction organization, exception handling, CLOB manipulation and dynamic SQL.
• Provided technical on-site production support on various Oracle issues including database performance tuning, database internals and other administration issues.
• Involved in designing level of application and developed teh Data model for application using ERWIN/VISIO.
• Resolved many production issues dat would has brought down teh production systems.
• Developed shell scripts to refresh dev, systest and pre-prod databases using export/import utilities.
• Developed a shell scripts to load data from various groups using SQL*Loader and automation of tasks or jobs.
• Developed shell scripts to transfer and receive data from various groups using connect direct tools
• Developed a shell scripts and PL/SQL scripts to monitor databases.
• Responsible for gathering requirement information from teh end users related to functional needs.
• Fine-tuning stored procedure, packages, triggers using PL/SQL, scripts (Shell, Perl, and Sql), and C/java programs as required and LDAP tuning.
• Responsible for creating materialized views as well as dynamic views for different types of reports.

Environment: Oracle Golden Gate Replication, Oracle HTTP/WEBCACHE Oracle Fusion Middleware 11.1.1.7.0, Informatics Data Transformation Tool, Oracle 11g/ Rac10g/9i, PL/SQL, SQL * Plus, SQL * Loader, Golden Gate, Informatica Mysql, Perl, SQL * Net, Net 8, Java, Web Logic 8.0 XML, JSP, Erwin 4.0, Toad 7.X, iplanet, Connect Direct, Harvest, Linux, Sun Solaris 5.8.6, Windows NT/95/2000.

Confidential, Atlanta

Sr. Oracle DBA

Responsibilities:

• Data Modeling Database Architecture and Design Production.
• Oracle database support Application development support.
• Oracle database software installs Maintenance and improvement of production.
• Oracle database formulation and enforcement of Oracle database software install standards formulation and implementation of Oracle database automation standards.
• Patching Oracle database.
• Capacity analysis and planning Archived records Oracle database (data warehouse)
• Implementation DBA-related business tasks done.
• Developed strategies for disaster recovery, backup, testing, verification & validation, data cleansing.
• Improved performance by implementing new Oracle 8i features, such as materialized views.
• Responsible for performance enhancements (SQL tuning & process enhancements).
• Monitoring SQL Programming PL/SQL Programming
• Batch processing Performance monitoring and tuning SQL Trace / SQL Tuning.
• Wrote complex code using oracle public packages like dbms pipe, dbms sql, utl file etc. Also wrote several user defined package procedures as reusable objects based on business rules.
• Data Migration from teh Oracle 7.3 to teh Oracle 8i database according to teh new structure using SQL Loader and Toad.
• Wrote shell scripts to refresh dev, systest and pre-prod databases using export/import utilities.
• Wrote a shell scripts to load data from various groups using SQL*Loader and automation of tasks or jobs.
• Developed shell scripts to transfer and receive data from various groups using connect direct tools
• Developed a shell scripts and PL/SQL scripts to monitor databases.

Environment: Oracle 8i, PL/SQL, SQL * Plus, SQL * Loader, Mysql, Perl, SQL * Net, Net 8, JavaXML, JSP, Erwin 4.0, Toad 7.X, iplanet, Sun Solaris 5.8.6, Windows NT/95/2000.

Confidential, Jersey City

Sr. Programmer/Analyst

Responsibilities:

• Responsible for coding for call routines for Reports.
• Developed stored procedures, functions, packages using SQL and PL/SQL.
• Developed triggers for automation of application flow and to enforce business rules.
• Developed Oracle Database objects based on teh new requirements (Indexes, view, constraints etc).
• Wrote complex coding using Oracle Package procedures like dbms pipe, dbms sql, utl file and advance queuing etc. Also wrote several user defined package procedures as reusable objects based on business rules.
• Developed shell scripts to automatically download teh files from teh branch office and loading into table and using teh procedures to apply teh rules.
• Participation in project discussion, trouble shooting.
• Tuning of teh sql queries using explain plan, sql trace and tkprof.
• Migrating data from teh old VAX system to teh Oracle database using SQL Loader and Toad.

Environment: Oracle 9i/8i, PL/SQL, SQL * Plus, SQL * Loader, Perl, SQL * Net, Net 8, Erwin 4.0, VB, OEM, Toad 7.X, Visual Source Safe 6.0, Sun Solaris 2.7/2.6, Windows NT/95/2000, Sun Ultra Enterprise Servers E5000/E3500/E450/250.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Responsible for discussing software requirements of teh client and preparing functional documentation.
• Security Management by creating/maintaining of database users.
• Maintaining various table spaces.
• Using Pl/SQL developed stored procedures, functions for applying business logic and called from teh forms.
• Developed Forms e.g. Fund Master (Trusts Fund Detail. address etc), Statutory Limits for Investment, Trustees and Preferred Limits for Investment, Cash Flow Items Master, Tolerance Limit,
• Extensively used forms objects like alerts, loves, record groups, master detail, visual attributes, property class, program units.
• Reports - Interest Re-investment Investment Variance Analysis, Switches Variance Analysis Report, and Compliance Snap Shot, Incremental Investments - Pattern Compliance-YTD.
• Ensuring Database integrity by implementing integrity constraints.
• Developed database triggers for updating database.
• Prepared Reports for bank administration and customers.
• Used SQL*PLUS to perform Complex queries against Database.

Environment: Oracle 8.1.6, Sql, Pl/Sql, Sql Loader, Shell Scripting, Toad 7.x, Sql Navigator, Oracle Designer, PRO*C, Forms 5.0, Reports 3.0, HP-Unix 10.10, Windows NT/95.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Planning / Pre-Survey, System Design, Programming, Implementation.
• Developed Forms for contract module, finance module, money market module.
• Developed Reports for money market, Deal slip printing, Placements made, Maturities due, Interest earned, Interest paid, Instrument-wise lending & Borrowing, Client-wise lending & Borrowing, Effective interest rate for net Borrowings & lending. Dealer Performance Reports.
• Developed MIS Reports for Appreciation/ Depreciation, Interest Overdue on fixed income securities, Primary Market investments, projected Cash flow, Industry-wise exposure, Movement in Portfolio, Yield to Maturity, and Comparison of Net present values of interest bearing Securities etc.
• Designed & developed packages, procedures & functions in PL/SQL.
• Tuning and optimization of application SQL for performance.

Environment: Oracle 7.3, Forms 4.5, Reports 2.5, PL/SQL 2.1, Tuning TKPROF and Explain PlanSQL*Loader, Windows NT/95, Sco UNIX 5.0

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Money Market Operations and Net asset values calculations (NAV).
• Requirement Study - co-ordinations with teh in-house functional officials to understand teh needs.
• Translating teh Business Needs of company in a Systems Approach viz., Design of tables, screen & pre-screen logic, Functional Logic of teh programs.
• Wrote stored procedures and functions.
• Developed user interactive forms for Deal processing, Back Up operations, Reconciliation, Accrued Interest calculation, Money Market Operation.
• Developed reports using Report writer 2.5 for calculation of accrued interest on Debenture and other debt securities, Printing Documents as Brokers Statement and Custodian Statement reports, Bank Reconciliation Statements, Journals, etc.

Environment:Oracle 7.0, PL/SQL, Tuning TKPROF and Explain Plan, Developer-2000, SQL*Loader