Summary

I have over fourteen years of total experience and 3 years 7 months of US experience in database administration and back-end coding. I have strong experience as Oracle database administrator and leading a big team. I have good Experience and extensive knowledge in Database Fine-tuning and optimization on Oracle 12C/11G/10G/9I/8I/8.0/7.3, Database Administration and data replication tools like golden gate and shareplex. I also have Extensive Domain Expertise in aeronautics Industry operations.

HIGHLIGHTS OF PROJECT EXPERIENCE

Confidential

Oracle Database Administrator

Role

• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Provide on call support to production databases, database maintenance, housekeeping and installs.
• Develop and maintain a disaster recovery plan.
• Research, Plan, review, and implementing database upgrades/patching.
• Responsible for performance tracking, capacity planning, tuning and troubleshooting of database servers with size ranging from 1 to multiple Terabytes, with a user base of around 80000.
• Manage Oracle database configurations utilizing Golden Gate and Data Guard to ensure maximum availability and data protection.
• Tune Oracle databases for peak performance using Dictionary views, AWR, ADDM reports. Periodically inspect, Identify and resolve harmful latch and I/O contention.
• Upgrade the databases from 8i to 9i, 9i to 10g and 10g to 11g and regularly applying critical patch updates.
• Have fine-tuned numerous SQL statements for batch operations, which reduced processing time from several hours to few minutes.
• Tuning of SQL's and Application Modules.
• Provide guidance to the development team to write tuned SQL statements and to tune ad hoc SQL's to run at optimum Performance.
• Work with Oracle internals including configuration parameters and experience with packages that could benefit management of production databases.
• Installation and maintenance of Oracle data guard for Physical standby databases
• Conduct regular team meeting among the different project development group and facilitate the discussion, monitor what was accomplished in the meeting and provide the basis for the agenda of the next meeting.
• Supervise development team in programming standards, code reviews and testing procedures and resolving any problems.
• Setting up database replication to branch the load of reporting queries to different server.
• Diagnose the problem areas and come up with solutions and/or workarounds.
• Perform a variety of complex administrative and technical work managing the database, troubleshooting, performance and tuning, data replication, data guard and system management.
• Regularly review and change access authorizations to database and verifying that unauthorized persons cannot access data.
• Oversee Oracle server access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
• Extensive use of RMAN for backup and recovery.
• Manage multiple oracle databases using enterprise manager 12c.
• Automating database tasks through oracle enterprise manager.
• Work with Oracle internals including configuration parameters and experience with packages that could benefit management of production databases.
• Convert non-ASM instance to ASM instance using RMAN
• Administer ASM instance by using SQL plus and ASMCMD command line

Confidential

Oracle and SQL DBA August

• Setting up standby servers at various geographical locations as a means of providing disaster tolerance.
• Analyzed past reports to identify harmful trends such as row chaining, fragmentation. Reviewed Changes in segment growth to check harmful growth periodically. Troubleshoot database problems using the trace files.
• Worked on Partitioning, Materialized views to improve performance.
• Initiated, designed and managed the development of MIS and various decision support business reports to update the management about business performance.
• Initiated, designed and developed decision support system from the aircraft maintenance/inventory/flight scheduling OLTP systems for various aircraft manufacturers to either get an agreement to exclusively use their maintenance manuals and other materials or to get endorsed our maintenance management service for all their company manufactured aircrafts.
• Written scripts to migrate data from mainframe to oracle and compare the data after migration.
• Logical Backup of Databases using EXP/IMP Utility EXPDP IMPDP and perform schema refresh
• Computerized and automated various procedures to ensure seamless business operations.
• Develop and control the database and IT security policy.
• Mentor and coach technical team members in best practices related to Oracle database design and development.
• Understand business requirements and related impact on database design.
• Design views to enforce security rules.
• Design schedule for processing files, purging data, running aggregations.
• Resolved nearly all performance issues for Aircraft maintenance, inventory and flight scheduling and engine trend monitoring system projects by rewriting SQL statements and guiding the development and the DBA team.
• Guiding the team to Setup development/test/demo servers for the company and their clients.
• Review the database design and make recommendations regarding enhancements and Improvements
• Write triggers for demoralized columns, Audit Trailing and to enforce business rules, stored procedures and packages.
• Involved with Analysis, Design, Developed, Testing and Implementation for various Industry Application such as Aircraft maintenance and Aircraft Inventory.
• Controlling and monitoring users access to the database.
• Guiding the DBA team in maintaining the database structures, which include altering storage settings for objects for optimum performance.
• Create and maintain physical / logical structures of the Database.
• Perform Periodic Maintenance of Databases with Database online Reorganization.
• Space Management and Performance Tuning.
• Control and monitor users access to the database, which includes creating, managing and dropping database users.
• Administer data and system programming in the enterprise's database computing environment, including configuration, security, resource monitoring and reporting, troubleshooting, performance and tuning, data replication, schema management, space management, database backup and recovery, disaster recovery, database refresh and the development of specialized programs.
• Maintain and monitor applications, databases, data and batch processes.
• Helps in database design, programming, troubleshooting and management of problems affecting IT and enterprise database applications, as well as developing the area for future expansion.
• Make suggestions/recommendations based on data manipulation needs of the Application.
• Supporting new development projects by designing, creating, and installing the necessary environments and applications with help from the application development team.
• Defining and designing logical and physical relational data structures by reviewing and understanding data usage requirements and needs with the development team and users.
• Run diagnostics and troubleshoot bottlenecks. Support existing applications and excellent trouble shooting skills.
• Develop non-restrictive standards for all database platforms Monitoring and tuning database subsystems on all platforms including changing device allocations and file size, building indices, reorganizing tables, purging data, and performing validation checks to ensure optimum database performance.
• Provides backup database administration for databases assigned to other DBAs. Provide technical guidance to other database administrators and application developers.
• Understands business functional requirements and guide the team to transform them into SQL, PL/SQL code.
• Development of in house decision support applications.
• Responsible for planning, coordinating, and administration of Oracle database s , including base definition, structures, documentation, upgrades, long-range requirements, operational guidelines, and protection.
• Resolving Oracle errors and failures, auditing activities, and resource utilization.
• Database connectivity management and troubleshooting SQL Net .
• Quest tools and Shareplex replication.
• Experience using data transfer utilities like DTS, SSIS, SQL developer and oracle workbench.
• Automating database tasks through oracle enterprise manager.
• Manage SQL server database versions 2000,2005 and 2008.
• Query and instance tuning using oracle enterprise manager.
• Secure enterprise data using Oracle Advanced Security Transparent Data Encryption.