SUMMARY

• 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.
• Senior Database Administrator (DBA) with advanced certifications and over 14+ years of proven expertise in Migration to PostgreSQL, EnterpriseDB Postgres Plus Advanced Server and Oracle database systems.
• Wide knowledge of other databases like Oracle, MYSQL, MS SQL Server and all other related programming languages, software tools, and Internet technologies.
• 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: PostgreSQL 9.6/9.5/9.3/9.0/ 8.2/7.4.6/7.3.4 , Oracle Database 12c/11g/10g/9i/8i, MySQL 5.0, Amazon AWS RDS, AWS Aurora for PostgreSQL (Preview), AWS DynamoDB (NoSQL), MongoDB, EDB Postgres Advanced Server 9.5/9.3, 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), Oracle Golden Gate, 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 EnterpriseDB Postgres Plus Advanced Server 9.3
• Responsible for installing, configuring, upgrading, and administering of PostgreSQL 9.6/9.5/9.4/9.3/9.1 , EnterpriseDB Postgres Plus Advanced Server 9.5/9.3 and Oracle Database 11g/10g databases in Linux environments.
• In the process of upgrading the Oracle Database from 11g to 12c.
• Automated the DBA activities for PostgreSQL, Oracle and EDB Postgres Advanced Server.
• Involved in implementing the Amazon AWS RDS (PostgreSQL) and scalability tests for Aurora for PostgreSQL (Preview).
• Migrated the on premises PostgreSQL, Oracle databases to Amazon AWS RDS using Amazon AWS Data Migration Services (DMS) and AWS Schema Conversion Tool.
• Configured, administered and maintained MongoDB database.
• Involved in Implementing and support of Amazon AWS DynamoDB (NoSQL).
• Administration of MYSQL 5.x on Linux Platform.
• Maintained and Optimized PostgreSQL, EDB Postgres Advanced Server Databases Performance through tuning.
• 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.6/9.5/9.3/9.1 on a 24x7 basis.
• Troubleshooting performance issues and fine-tuning queries stored procedures for Oracle 11g/10g.
• Install, Configure and troubleshoot Oracle Golden Gate in Production.
• 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: PostgreSQL 9.6/9.5/9.4/9.3/9.1 , EDB Postgres Advanced Server 9.5/9.3, Oracle Database 12c/11g/10g, AWS RDS (Postgres) and Amazon Aurora for Postgres (Preview), AWS DMS, AWS Schema Conversion Tool MongoDB, Amazon AWs DynamoDB (NoSQL), MySQL 5.x, Linux (CentOS 7/6, Red Hat), Oracle Golden Gate, 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

Confidential, Redmond, WA

Senior Database Administrator (DBA)

Responsibilities:

• 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 9i/10g, 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: 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)

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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.

Confidential

Oracle DBA/Developer

Responsibilities:

• Analyze, Design, and develop the new Biomedical Equipment System Project
• Wrote PL/SQL Packages, Stored Procedures, Database Triggers
• System Testing using Test and Production Data
• Developed and implemented Service Control System Module
• Design, development, and coding of Hospital Management Information System.
• Developed modules: Appointment, Patient Registration, Diagnosis Reports, Lab Information System, Drug information, Billing and Accounting System, Stores Management, Medical Records, Administration and inquiry
• Developed Forms/Reports & Test the application.

Environment: Windows NT 4.0, Oracle 7.3, Developer 2000 (Forms 4.5, Reports 2.5 and Graphics 2.5), PL/SQL 2, SQL*Plus, SQL Loader, Procedure Builder, Oracle Browser (Discoverer 2000).

Confidential

Oracle Developer

Responsibilities:

• Developed and coded Inventory Control System.
• Developed modules: Purchase Information, Information of Suppliers, Account Payable and Accounts Receivables.
• Developed Purchase Transaction Form, Customer Payment Form, Sales Form.
• Developed Stock Level Reports, Reorder Level Reports and Pending Orders Reports.

Environment: HP-UX, Windows 95, Oracle Forms 4.5, Reports 2.5, PL/SQL, SQL*Plus

Confidential

Oracle Developer

Responsibilities:

• Designed and developed Financial Management System
• Developed modules: Sales Form, Purchase Form, Credit Sales Form, Account Receivables and Account Payables.

Environment: SCO UNIX, Windows 3.1, Oracle 6.0, SQL*Forms 3.0, SQL*Report writer 1.1, PL/SQL, SQL*Plus