PROFESSIONAL SUMMARY:

More than 15 years of hand - on experience with Oracle, PostgreSQL and SQL Server on UNIX, Linux and Windows allow me to do DBA job faster and better than you can expect.

TECHNICAL SKILLS:

Tools: SQL, SQL*PLUS, SQLcl, PL/SQL, PSQL, Bash, Korn Shell, Perl, Python, PowerShell, SQL Developer, DataGrip, pgAdmin, Liquibase, TOAD, ERwin, Git, Pentaho, NetBackup, CommVault.

Databases: Oracle 12c/11g/10g/9i/8i (RAC, ASM, OEM, Data Guard, RMAN, Golden Gate, DataPump, Streams, Partitioning), PostgreSQL 9, SQL Server 20012/08/05, MySQL.

Platforms: UNIX (AIX, HP-UX, Solaris, Linux, Exadata), Windows Server 2008/2003/2000 , Windows 10/7/XP/NT, AWS, RDS.

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Oracle/PostgreSQL DBA

Responsibilities:

• Create and maintain project coding standards and naming convention.
• Modify PostgreSQL database functions for better performance and structure.
• Optimize Oracle procedures source code for better performance.
• Database physical modeling and normalization using SQL Developer and pgModeler.
• Create and maintain database source code repository using Atlassian SourceTree and Bitbucket.
• Create project documentation using Atlassian Confluence.
• Developed procedure to create Postgres instance on AWS EC2 server.
• Create procedure to generate DDL for database schemas.
• Create and maintain database replication on AWS RDS using GUI and CLI.
• Clone PostgreSQL instance using pgdump and snapshots.
• Cleanup existing application data based on business requirements and data integrity.
• Monitor and maintain Oracle database storage for Production, QA and Development.
• Implement database patching and upgrade in all environments.
• Create and maintain shell scripts to backup and restore Oracle and PostgreSQL databases.
• Manage database security on Operating System level and Application level.
• Use AWS CLI to manage databases in RDS.
• Use Liquibase for version control database DDL, DML and source code.
• Create infrastructure to integrate Liquibase and Bitbucket.

Environment: Oracle 11g/12c, PostgreSQL 9.4, Linux, AWS (EC2, RDS), Jira, Git, Liquibase.

Confidential, Rockville, MD

Oracle and PostgreSQL DBA/Developer

Responsibilities:

• Work with Development Team to modify database design for better performance and maintainability.
• Database logical/physical modeling and normalization using ERWin and Oracle Data Modeler.
• Maintain database source code and documentation using Atlassian SourceTree and Bitbucket.
• Cleanup existing application data based on business requirements and data integrity.
• Fix performance problem (report execution time was reduced from 18 hours to 20 minutes).
• Analyze Oracle performance problem using AWR and ASH.
• Setup multi - tenant databases in Oracle 12c in Development and QA environments.
• Setup Oracle auditing tracing using DBMS FGA package.
• Monitor and maintain Oracle database storage for Production, QA and Development.
• Implement database patching and upgrade in all environments.
• Create and maintain shell scripts to backups and restore databases using RMAN and pgdump.
• Manage database security on Operating System level and Application level.
• Redesign Oracle application architecture to prepare for migration to PostgreSQL environment.
• Develop procedure to migrate source code and data from Oracle to PostgreSQL in AWS.
• Generate PostgreSQL DDL from Oracle DDL using ora2pg and AWS tool.
• Fix compilation problems in generated PostgreSQL source code.
• Setup Pentaho to replicate data between Oracle databases to replace Golden Gate
• Setup Pentaho to replicate data from Oracle to PostgreSQL on AWS.
• Use JAMS scheduler to create batch jobs for database synchronization.

Environment: Oracle 12c, PostgreSQL 9.4, Linux, AWS, Jira, Git, Liquibase, JAMS.

Confidential

Operational DBA Oracle/SQL Server

Responsibilities:

• Develop standard procedure for database installation, upgrade, patching and decommission.
• Installation, maintenance and troubleshooting of Oracle RAC Grid Infrastructure.
• Manage users, logins, accounts, permissions, roles for all databases.
• Oracle Data Guard with FSFO and Fast Sync configuration, monitoring and support.
• Performance problem was found and fixed for DataPump jobs started from OEM.
• SQL Server mirroring setup and management.
• Python script was created to report failed OEM backup jobs.
• Performance tuning was done for third - party applications using advanced tracing technics.
• Develop procedure to cleanup Oracle temporary files using ARCI to free disk space.
• Perl script was created to reset Oracle passwords on hundreds of databases.
• Develop procedure to improve listener configuration and monitor DB connectivity.
• Perl scripts were created to maintain inventory of Oracle databases and SQL Server instances.
• Create, test and maintain set of corporate naming convention standards.
• Create and maintain set of Shell and Perl scripts for database cloning and refresh using RMAN.
• Create PowerShell scripts to monitor users, logins, and jobs on Windows.
• Monitor space usage and refresh SAP databases.
• Create scripts to implement alert-based transaction log backups using NetBackup.
• Golden Gate installation, setup and maintenance in all environments.
• Upgrade Oracle databases from version 10g to 11g and from 11g to 12c.
• Manage application schemas and metadata, perform application PL/SQL code review.
• Setup OEM 12c to manage all Oracle backups using NetBackup.
• Troubleshooting database performance and backup issues using AWR and ASH.
• Create set of Perl scripts to monitor Oracle databases and send alerts to DBA.

Environment: Oracle 10g/11g/12c with RAC, Data Guard and Golden Gate on Oracle Solaris 10/11 and Linux.

Confidential, MA

Oracle DBA

Responsibilities:

• Implementation of Oracle Data Guard with FSFO. Downtime was reduced from several hours to several seconds in case of Primary database or server failure.
• Implementation of Oracle EM infrastructure including WebLogic Server, OMS, OEM Agents and patching for all components.
• Install and manage RAC with ASM infrastructure on Linux.
• Create set of monitoring scripts using SQL, Shell, Perl, and Python to send e - mail alerts, collect and visualize statistical data.
• Implementation of Golden Gate bi-directional data replication between Data Centers to allow uninterrupted access to application data in case of Data Center outage.
• Performance tuning to keep database response time less than 3 seconds while database grows from 200GB to 12TB in size.
• Database tuning with AWR and ADDM for Apple Siri to support up to 50M requests per day.
• Develop procedure to cleanup Oracle internal latches (mutex) to avoid 100% CPU usage.
• Use Virtual Machines (VMware/VirtualBox) to work around limitation of only one VPN connection at the same time.
• Test and implement database migration from Oracle 11g to Oracle 12c.
• Setup environment for DBA team to continue OS/Database sessions after network failure using tmux and GNU screen.
• Create set of network monitoring scripts to find root cause of Data Guard failovers.
• Create and maintain knowledge database of DBA team using World Press.

Environment: Oracle 11g/12c, Windows 7, Enterprise Linux with Data Guard and Golden Gate.

Confidential

Oracle DBA

Responsibilities:

• Install and configure OEM infrastructure with Apache, OMS, Repository and Agents.
• Proactively monitored systems 24/7 by creating automatic alerts using Perl scripts.
• Reconfigured all production CommVault backup jobs to run faster and consume fewer resources.
• Develop and implement procedure to prevent database hang - up because of MS Windows memory leak.
• Upgrade databases from Oracle 9i and 10g to 11g Release 2; deployed projects with no production downtime.
• Seamlessly migrated 100GB of data from Oracle to SQL Server for SAP development over 2 days using Oracle Gateway.
• Took initiative to clean up and standardize Oracle network configuration files.
• Leveraged Oracle and Perl expertise to help IT infrastructure team build an automated system for inventory management.

Environment: Oracle 11g/10g/9i/8, SQL Server, Windows 2008/2005.

Confidential

Oracle DBA. Consultant

Responsibilities:

• Implemented Oracle procedure for creating Data Guard (physical standby).
• Developed Perl script (with SSH module) to collect Oracle stats on remote servers.
• Resolved long - standing problem with nightly backup failures; identified root cause and recommended corrective actions.
• Completed Oracle 10g and 9i upgrade, patching and cloning.
• Successfully completed all jobs working 100% remotely.

Environment: Oracle 10g/9i/8, AIX 5.3/5.2, Solaris 5.8, Linux.

Confidential, Portland, OR

Oracle DBA

Responsibilities:

• Efficiently implemented 2-node RAC database on Solaris; project involved checking pre-installation requirements, operation system parameters and network equipment configuration, as well as installation of Oracle Clusterware, Oracle databases and monitoring.

Environment: Oracle 10g/9i/8, HP-UX 11.23, Solaris 9.

Confidential, Seattle, WA

Oracle DBA

Responsibilities:

• Installed/configured Apache Web Server, Oracle Grid Control and Intelligent Agent.
• Performed Java applications support and performance tuning.
• Created scripts for database monitoring, event notification and statistics visualization.

Environment: Oracle 10g, Solaris 9/8, Perl