SUMMARY

• 10+ Years of experience in database administration, project management and database Design, Modelling and Implementation of Business Applications using Relational database Management System.
• Experience in Production Support with managing relational databases and database performance tuning, monitoring, DB health check at leading clients (Finance, Banking, Federal Government, telecom, Retail).
• Oracle 10g, 11gR2, 12c Database Administration
• 24/7 production and development support - Oracle and MS SQL Server Administration
• Disaster recovery plans by implementing 10g/11g Oracle RAC and Data Guard switchover and failover
• Oracle core DBA skills for supporting Oracle database 10g/11g with RAC/Non-RAC on Linux Server
• Creating Databases, Database Design and managing user securities on both Oracle and SQL Server
• Logical and Physical database modelling with UML tools
• RDBMS Installation, Creating and Managing OLTP and OLAP Database
• Backups using RMAN and DATAPUMP/Backup policy using RMAN
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
• Implementation of high availability solutions with Oracle 11g RAC, Physical Standby database, Data Guard
• Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM
• Developed complex database objects like Stored Procedures, Functions using SQL and PL/SQL
• Proficient in SQL, PL/SQL, Unix/Linux Shell Scripting and analyzed Batch programs
• Administration and Management -Database Links, Oracle Golden Gate (Data Replication)
• Experience in managing Oracle WebLogic server 12 and related components
• Troubleshooting production issues and raising high availability and scalability database solutions using replication
• Good written and verbal communication skills, analytical, relationship management and problem-solving skills
• 2 years of experience in MySQL Database versions used 5.0,5.5
• Strong interpersonal skills, ability to work with cross functional teams
• 2 years of experience in MS SQL Server Database Version 2005,2008 and 2012
• Conceptually having knowledge of NoSQL database solutions
• Good experience in analyzing Oracle AWR (Automatic Workload Repository) reports for performance bottlenecks and for top resource consuming SQL queries
• Additionally, having implemented practices for SQL and PGS sizing and involved in documentation of known database problems as they arise

TECHNICAL SKILLS

Databases: Oracle 12c/11g/10g, MySQL, MS SQL Server 2005/2008,2012, MS Access, RAC, Golden Gate, AWS RDS

Operating Systems: UNIX, Linux Red Hat, MS Office Suite ( ), XML

Languages: PL/SQL, Unix Shell Scripting, HTML, Java Scripting

Project Management: Change Management, Software Development Life Cycle, Business process Improvement

RDBMS Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces Loader, RMAN, expdp/impdp, ADRCI, EMCLI, Management Studio and Word Bench

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, Toad, Informatica, WinSCP, SQL Developer, OEM

PROFESSIONAL EXPERIENCE

DBA Consultant

Confidential

Responsibilities:

• Reached throughput by 50% monitoring database health check using automated scripts.
• Saved 2 hours by fine tuning long running database queries and Systems Management through generated reports.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Enhanced database performance by 70% through tuning method and using SQL Profile.
• Maintained costs 30% under budget with help of scripts using PL/SQL programs and jobs batch process integration between database and application server to execute batch process to avoid use of third-party tools and save company's money.
• Developed Shell scripts, PL/SQL scripts to monitor Golden Gate processes and their status running.
• Analyzed web server and application problems, improved operations and provided exceptional client support. Allocated recommendation to existing application increasing worker efficiency.
• Reduced annual expenses 15% by leading cost reduction by using scripts to integration with application batch process with oracle database scheduler and worked with project team of 15 people.
• Experience deploying, administering and managing SaaS and PaaS Technology.
• Worked on user authentication by assigning different roles.
• Worked with moving Oracle and MySQL databases over to AWS both EC2 and RDS.
• Performed daily Database administration tasks: User management, Space monitoring, Alert Log monitoring.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data Guard on oracle 11g and 10g.
• Migration of database objects across platform.
• Performing routine backup and recovery testing, including testing and documenting recovery scenarios.

Database Administrator

Confidential

Responsibilities:

• Responsible to develop efficient Procedures, PL/SQL code to monitor database growth and database performance and optimize database load and manage more than 5 database servers.
• Automated the nightly RMAN backups for the Production, Development and Test Databases using Crontab.
• Involved in performance tuning using Performance monitor tools, SQL Profiler, SQL Query Analyzer and Index tuning wizards, database Engine Tuning Advisor.
• Implemented database clustering using 2 node Oracle RAC in Linux environment and maintain database availability with shared storage.
• Hands on experience on Active data guard and Golden Gate replication configuration, support and maintenance with good troubleshooting skills.
• Extended support in project having more than 10 databases of size in Terabytes.
• Handled situation when production application server went down due to property file issue and fixed it by dedicated work of 4 hours.
• Demonstrated experience administering Oracle 11g, Oracle 12c, RAC, Advanced Streaming and Data Guard.
• SQL Server tools like export, import wizards, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Managed a $1.2 million data-integration project for financial services migrating legacy data into Oracle Cloud environments.
• Attended to customer service requests like SQL and database tuning.
• Developed and maintained PL/SQL stored procedures, DDL, DML, ETL scripts and triggers for various academic web-based applications.
• Constantly monitor the performance of the Databases and viewing Alert log files and Trace files.
• Have good understanding on the MySQL internals.
• Creating change requests utilizing supported change management tool (JIRA).
• Optimized the performance tuning of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.
• Extensive implemented Data pump, conventional Export/Import (Oracle 11g,10g) for migration and logical backup of the database.
• Develop SQL based solutions to handle requirements from developers in the SQL Server 2008 back-end databases.

Database Administrator

Confidential

Responsibilities:

• Build High availability and Disaster recovery environment using Data guard environment for production environments and automated scripts to monitor the status.
• Worked on SQL Server DB Security of creating logins, users, roles and assigning permissions to them.
• Implemented RMAN backups (Hot, Cold, full and incremental) as per backup policy and also perform recovery.
• Provided database related services to Development and QA environments as Database Refresh/Cloning and Object Migration.
• Demonstrated effective oral and written communication skills with the ability to communicate technical information to non-technical personnel.
• Implemented MySQL backups using mysqldump and MEB.
• Load FLAT files to MySQL Database using TOAD Data in file.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and Database performance tuning.