PROFILE:

• Senior Database Administrator (DBA) with advanced certifications and over 14+ years of proven expertise in Oracle database systems, Migration to PostgreSQL and EDB Postgres Advanced Server.
• Wide knowledge of other databases like Oracle, PostgreSQL, MYSQL, MS SQL Server and all other related programming languages, software tools, and Internet technologies.
• Highly focused and in - depth PostgreSQL Data Migration Specialist with a superb record of achieving results and a passion for helping organizations maximize their investment in PostgreSQL
• Skilled in all aspects of system deployment ranging from initial system architecture to data migration, deployment, customization, and daily maintenance.
• Able to function effectively as part of a team as well as independently. Wide knowledge of all applicable data management computer software.

TECHNICAL SKILLS:

Databases: Oracle Database 11g/10g/9i/8i, PostgreSQL 9.5/9.3/9.0/ 8.2/7.4.6/7.3.4, EDB Postgres Advanced Server 9.5/9.3, Amazon AWS RDS, Amazon AWS DynamoDB, MySQL 5.0, MS SQL Server 2000/7.0/6.5

Operating Systems: Linux (CentOS 7/6, Red Hat, Fedora, Suse, Ubuntu), Sun Solaris 5.10/5.9, Windows XP/NT/2000/95

Languages: SQL, PL/PGSQL, PL/SQL, TSQL, PRO*C, HTML, XML, JAVA, JSP, UNIX shell script, Perl Script

PostgreSQL Tools: PgBouncer, pgPool II, EnterpriseDB Postgres Enterprise Manager (PEM), EnterpriseDB Replication Server, Slony Replication, PostGIS, EDB*Plus, Clusterdb, Createdb, Createlang, Createuser, dropdb, Ecpg, pg basebackup, Pg config, Pg dump, Pg dumpall, Pg isready, Pg receivexlog, Pg restore, PgBadger, Reindexdb, VacuumDB

Oracle Tools: Oracle Real Application Clusters (RAC), Oracle Enterprise Manager (OEM), Advanced Queuing, Oracle Replication, Data Pump, SQL*Loader, Export, Import, Schema Manager, Server Manager, SQL Expert, SQL Analyzer, Standby Database (Oracle Data Guard), Oracle Replication, Oracle9i Developer Suite, Oracle 9i/10g JDeveloper, Oracle Forms 6i/5.0/4.5, Oracle Report6i/3.0/2.5, Oracle Graphics, Oracle Discoverer (Including EUL), SQL Navigator 4.x/3.x, TOAD 8.6/7.5/7.2/6. x, DBA Studio, Oracle Warehouse Builder, Oracle Migration Workbench

Application Servers: Orion, Oracle9i Application Server Release 2 (9.0.2.0.1), Apache

Case Tools: Oracle Designer 9i, Oracle Designer R6.0, Oracle Designer 2000

Other Tools: Source Forge, Perforce, Remote Sunbelt Administrator, Veritas Netbackup, SecureCRT, WinSCP, Putty, and Intersolve PVCS, Rational Clear Case, Symantec Ghost, Vice Versa. SubVersion

PROFESSIONAL EXPERIENCE:

Confidential, Seattle WA

Senior Database Administrator DBA

Responsibilities:

• Gathered data and presented a case to senior management to change direction and Migrate from oracle to EDB Postgres Plus Advanced Server 9.3
• Responsible for installing, configuring, upgrading, and administering of Oracle Database 11g/10g databases, PostgreSQL 9.5/9.4/9.3/9.1 and EDB Postgres Advanced Server 9.5/9.3 in Linux/Unix environments.
• Automated the DBA activities for Oracle, PostgreSQL and EDB Postgres Advanced Server.
• Maintained and Optimized Oracle, PostgreSQL, EDB Postgres Advanced Server Databases Performance through tuning.
• Involved in implementing the Amazon AWS RDS and Aurora.
• Migrated the on premises PostgreSQL, Oracle & MYSQL databases to Amazon AWS RDS and Aurora Databases using Amazon AWS Data Migration Services (DMS) and AWS Schema Conversion Tool.
• Involved in Implementing and support of NoSQL (DynamoDB).
• Developed scripts for PostgreSQL, EDB Postgres Advanced Server databases for monitoring and tuning procedures.
• Coordinated with other software development teams for fixing technical issues and database errors.
• Support PostgreSQL, EDB Postgres Advanced Server databases running on different versions 9.5/9.3/9.1on a 24x7 basis.
• Migration of oracle database 10g to 11g and also the environment change from Solaris to Linux.
• Ability to analyze, evaluate and recommend new tools and technologies to management to enhance the business components.

Environment: \Tools: Oracle Database 11g/10g, PostgreSQL 9.5/9.4/9.3/9.1, EDB Postgres Advanced Server 9.5/9.3, AWS RDS and Aurora, AWS DMS, AWS Schema Conversion Tool, DynamoDB, Linux (CentOS 7/6, Red Hat), EnterpriseDB Migration Toolkit, PgBouncer, pgPool II, EnterpriseDB Postgres Enterprise Manager (PEM), EnterpriseDB Replication Server, Slony Replication, PostGIS, EDB*Plus, Clusterdb, Createdb, Createlang, Createuser, dropdb, Ecpg, pg basebackup, Pg config, Pg dump, Pg dumpall, Pg isready, Pg receivexlog, Pg restore, PgBadger, Reindexdb, VacuumDB, Subversion (svn)Confidential, Redmond, WA

Senior Database Administrator DBA

• Responsible for design, installation, configuration, upgrade, and administration of Oracle 10g/9i, PostgreSQL 8.2/7.4.6/7.3.4 and MYSQL 5.0 databases in Unix/Linux environments.
• Database Development of Oracle 9i/10g, PostgreSQL 8.2/7.4.6/7.3.4 and MYSQL 5.0
• Troubleshooting performance issues and fine-tuning queries stored procedures for both Oracle 10g/9i, PostgreSQL 8.2/7.4.6/7.3.4 .
• Built, configured and maintained Oracle Real Application Clusters (RAC).
• Evolved the company’s database strategy and worked to ensure that the new database deployments conform to business needs.
• Worked with other teams within Confidential to understand the application architecture and resolve issues within any part of the database/application.
• Managed multiple projects while balancing production needs to ensure deliverables are met.
• Identified and implemented continuous operational & process improvements.
• Participated in the evaluation, recommendation, and prototyping of new database designs along with java application solutions.
• Evaluated & tested proposed changes to the environment in QA and Scale Group.
• Worked on directly troubleshooting activities with the clients during outages coordinated and engaged internal resources while ensuring timely communication to stakeholders.
• Wrote code and created jobs to automate repetitive tasks.

Environment: \Tools: Oracle Database 10g/9i, PostgreSQL 8.2/7.4.6/7.3.4, MYSQL 5.0, MS SQL Server 2000, Oracle Real Application Clusters (RAC), Oracle JDeveloper, TOAD 8.6/7.5/7.2, SourceForge, Perforce, Orion Application Server, Java, TextPad, JEdit, Sun Solaris 5.10/5.9, Linux (Red Hat, Fedora, Ubuntu, Suse), IronEye SQL, Aqua Data Studio, Oracle Migration workbench

Confidential, Bellevue, WA

Oracle Database Administrator/ DBA

• Primary Database Administrator (DBA) for 24x7 Oracle Production Database and additional management/monitoring of 20 databases
• Designed, installed, configured and upgrade of Oracle server software and related products.
• Significantly increased performance of the main corporate QIPS application (Quality Insurance Product Services) by tuning Database parameters and SQL, PL/SQL statements.
• Migrated Oracle 8i Database from Windows to Sun Solaris Platform and achieved 8x speed increase.
• Wrote a Large Table Transfer (ltt) script in Perl to transfer the Big Tables spanning several Giga Bytes from Production Database (Unix Platform) to Testing/Development Databases (Windows NT/2000 Platform)
• Perform Database Tuning & Performance, Coalescing, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management, Table Partitioning and Tuning SQL batch queries. Regular scripts were run to monitor and manage space in Table spaces.
• Designed/Installed/Configured Oracle 9i/8i Databases for different Production/Development/Testing environments.
• Implemented and maintained database security (create and maintain users and roles, assign privileges).
• Developed PL/SQL Stored Procedures, Packages, Functions & Database Triggers for QIPS application
• (Quality Insurance Product Services).
• Simplified the Administrative Task, Eliminate Redundancy by centralizing of Oracle Name.
• Administration of Data Modeling using Oracle Designer Tool and performed activities such as configuration of Applications and sharing/Not sharing them across multiple applications. Created complex E-R diagrams, Data flow diagrams, Server model configurations and Implementations. New repository creations and migrations. Created Designer databases and generation of driving scripts out of them. Generated reports using Designer Reports utility. Performed reverse engineering from Oracle database into the designer repository.
• Reorganized table spaces/data files for I/O load balancing and Managing Row Chaining, Creating Bitmap Indexing & rebuilding of Indexes for better performance.
• Coded Unix Shell Scripts and Perl Scripts to monitor and check the status of each backup.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Administration & Maintenance of Multiple Terabyte Warehouse Database.
• Establish and maintain sound backup and recovery policies and procedures using RMAN.
• Responsible for I/O Tuning using Explain Plan, TKProf, Statspack, Oracle replication support, Oracle Names Server & SQL*Net Configuration.
• Setup and maintain documentation and standards.
• Administration & maintenance of Real Application Clusters (RAC) using Oracle 9i on Sun Solaris Platform.
• Support the Production/Development/Testing team with day-to-day Database Issues like Configuring SQL*Net, Design/Implement Qips application & Performance.
• Administration/Maintenance of MySQL database using MySQL Control Center, MySQL Administrator.
• Designed, Installed, Configured, and tuned Oracle9iAS Release 2 (9.0.2) on Windows 2000.
• Administration of MS SQL Server 2000/7.0 including Documentation, Backup, Restore Maintenance, Monitoring, Upgrading and Troubleshooting.
• Data Importing/Conversion from Excel sheets sent by the client to the MS SQL Server database.

Environment: \Tools: Oracle Databases 9i/8i/8/7.3, MS SQL Server 2000/7.0, Real Application Clusters (RAC), Advanced Queuing, Standby Database (Oracle Data Guard), Oracle Replication, Oracle Designer 2000/9i, Oracle9iDS, Oracle9i JDeveloper, TOAD 7.5/7.2, SQL Navigator 4.x, SQL Expert, SQL Analyzer, Spotlight, TKPROF, Remote Sunbelt Administrator, Veritas Netbackup, SecureCRT, WinSCP, Putty, Intersolve PVCS, Rational Clear Case, Symantec Ghost, TextPad, Ultra Edit, Vice Versa, Sun Solaris 5.6, Windows XP/NT//2000, Red Hat Linux, Oracle 9iAS Release2 (9.0.2).

Confidential, Yakima, WA

Consultant Oracle DBA/Developer

• Installation & Configuration of Oracle 8.x on Windows Platform.
• Responsible for SQL & Database Tuning.
• Implement & maintain database security (Create & Maintain Users & Roles assign Privileges)
• Perform general technical troubleshooting and give consultation to development teams
• Developed PL/SQL Stored Procedures, Packages, Functions & Database Triggers.

Environment: Oracle 8i Database, Oracle Enterprise Manager 1.6, Sql Navigator 3.0, TOAD.

Confidential, Bellevue, WA

Consultant Oracle Developer

• Wrote Oracle Stored Procedures, Packages and Stored Functions using PL/SQL 2.3
• Used the Dynamic SQL, Cursors, Error Handling in Writing Procedures.
• Involved in Automated and manual testing and Debugging of PL/SQL programs.
• Responsible for Oracle SQL & Application Performance.
• Converted the MS SQL Server 6.5 Stored Procedures to Oracle.

Environment: Intel-based Server, Windows NT 4.0, Oracle 7.3, PL/SQL 2.3, SQL*Plus 3.3, Oracle Enterprise Manager, MS SQL Server 6.5.