PROFESSIONAL SUMMARY:

• 16 years of hands on experience in administering onsite and AWS cloud based relational and NoSQL database technologies including Postgre SQL, Oracle, and Sybase, MySQL, and Mongo.
• Expert knowledge of full application and software life cycle and in database migration from legacy system to modern platforms and cloud environment
• Extensive experience in database design, implementation, maintenance, performance tuning, database replication, database restore and disaster recovery.
• Proficient in Shell and Perl. Certified Oracle 11g and Sybase Professional.

TECHNICAL SKILLS:

• Oracle, PostgreSQL, Sybase ASE, Sybase Replication Server, MySQL, MS SQL, Teradata V2R4.0
• Perl, Shell, SQL, PL/SQL, PL/PGSQL, C/C++, Linux, AWS, Solaris,
• Patrol, Legato Networker, Sbacktrack, Obacktrack

EMPLOYMENT HISTORY:

Senior Consultant

Confidential

Responsibilities:

• As a database architect, lead a team in designing and implementing and migrating Oracle and MySQL database into PostgreSQL clusters with high redundancy, multi - site streaming replication to meet the Library of Congress congress.gov web portal.
• Procure Redhat VM boxes, install Oracle, Postgres, and MySQL software, implement Dev, Test, AT, and Production systems running PostgreSQL with streaming technology.
• Planning, testing, and implementing Oracle and MySQL databases migration into open source PostgreSQL server clusters using ora2pg, Talend, and/or custom-write Perl and Shell scripts as needed for performance and efficiency to meet task complexity and deadlines. Coordinate closely with developers in trouble shooting data and performance issues during and after the migration.
• Performance tune PostgreSQL where needed. Design, test, and implement backup and recovery strategies.

Senior Database Architect/Administrator

Confidential, Reston, VA

Responsibilities:

• As a key Database personnel, designed, setup, and implemented the whole FCC PostgreSQL database server database architecture. Designed schemas to suit various applications, implemented multi-site streaming replication and security configurations to suit the needs of Broadband Mapping Project and various other client projects using more than 70 server clusters in Amazon EC2, RDS, Amazon Redshift, and onsite and off-site Linux hosts.
• Supported Major database migration efforts from legacy systems to modern platforms. Designed, configured, and Implemented migration plans from legacy Sybase ASE and Oracle to PostgreSQL and from onsite database to Amazon Cloud using EC2, RDS, and Redshift with in-house written scripts and other ETL tools.
• Procured hosts with appropriate CPUs, Memory, Disk Space layouts for PostgreSQL Server configurations and setups. Created, maintained, and implemented database server configuration and security standards and enforce standard security policy across enterprise.
• Custom wrote tons of SQL, PL/PGSQL functions, Shell, and Perl scripts to establish performance benchmarks, to monitor database operations, to backup and recovery of databases, to collect database performance statistics, to analyze system bottlenecks and to propose solutions to eliminate them, as well as to standardize database/schema/user creation procedure and enforce security standard.
• Performed database tuning in the areas of server configuration changes, creation of different types of indexes, partitioning, application code tuning, streaming replication tuning, as well as automating standard database/user/schema creation, enforcing password security, and backup and recovery. Configured Server parameters tailored for specific application needs for performance gains. Synced up databases between primary and standby when need arise.
• Implement PostgreSQL Streaming Replications on multiple standby servers as query systems; tune primary and standby serves for high performance and reduce any latencies.
• Set up foreign database wrappers access/query Sybase and Oracle data from within PostgreSQL so that developers need to only be on one platform to query databases across different platforms at the enterprise level.
• Updated database servers from version 9.0 and 9.3 to version 9.5 with postgis and other extension components by downloading and installing packages and resolving dependencies. Resolving installation issues by searching online and subscribing PostgreSQL community forums. Recommended and implemented new features in current applications and database administrations for better performance gains.
• Designed, implemented, and tested data retention polices and disaster recovery strategies that meet client requirement. Tested recovery strategies on a regular basis. Conducted manhy point in time recovery of production database cluster, as well as logical database/schema restores to lower environment.
• Point-in-time production recovery and logical restore of databases when need arise.
• Managed Federal Agency’s mission critical Auction, Licensing, and GIS database center using Sybase, Oracle, mongo, MS SQL Server consisting of 200+ database servers with multi-terabyte data in a heterogeneous replicated environment that include Sybase Replication technology, Oracle Data Guard, and Sybase Enterpriseconnect Data Access for Oracle on platforms involving Solaris, Linux, and Amazon AWS cloud.
• Installed, upgraded, configured, and tuned Sybase ASE Server, Replication Server, and Oracle Servers as well as Oracle physical Standby databases.
• Wrote, tested, and implemented database replication from MS SQL to Sybase, and from Sybase to Oracle using Java, Sybase Replication Server, and Direct Connect for Oracle software. Configured and maintained coordinated database dumps through Sybase Replication server.
• Created and maintained replication definitions, subscriptions, custom function strings for all Sybase replication servers.
• Worked closely with development teams in database performance troubleshooting by recommending architecture and configuration changes and application code modifications to eliminate performance bottlenecks using various tools such as DBArtisan, OEM, AWR reports, ADDM, SQL tracing, and by analyzing execution plans.
• Routinely restored, refreshed and cloned database environments with production databases in support of ongoing application development life cycle in Sybase and Oracle using Data Pump, BCP, SQL*Loader, RMAN and flashback technology for application testing.
• Planed intergroup coordination of database software installation, database creation, upgrade, security patching, database migration, server and database consolidation with VMware virtualization on RHEL environment.
• Installed, set up, and configured Oracle Enterprise Manager (OEM) Grid Control and OEM Database Control, as well as BMC Patrol for custom designed administration job scheduling, point in time backup and recovery, proactive performance and Database operation monitoring, event notifications, security auditing, and database operation metrics collection and reporting, as well as automate Database Administration tasks.
• Designed, implemented, and maintained and migrated a complex cross-platform coordinated database backup strategies between Sybase and Oracle databases using Sybase replication, EnterpriseConnect Data Access, and RMAN technology for database high availability with custom written scripts.
• Promoted, implemented, and enforced best practices to achieve best performance gains in database architecture design, database backup and recovery, data retention policy, data integrity checks, database security, and coding practices unique and specific to each of the database technologies
• Developed extensive custom-made procedures, SQL, Shell and Perl scripts to assist and automate databases administration tasks as well as database migration.
• Set up mongo, MySQL database servers and replication, sharding data for better performance. Implement database backups strategies for mongo and MySQL.

Database Administrator

Confidential, Vienna, VA

Responsibilities:

• Administered Oracle 9i, Teradata, MS SQL Server
• Installed, upgraded, configured, and tuned database systems and SQL codes
• Wrote custom Perl and Shell scripts for database automation and job scheduling
• Monitored, troubleshoot, debugged, and fixed system database errors
• Wrote and maintained database performance report scripts
• Implemented data model changes and administered a Confidential MIP-RAS Unix system Supported on-call rotation

Database Aanlyst

Confidential, Atlanta, GA

Responsibilities:

• Installed, upgraded, and maintained Sybase, Oracle and their related products and tools
• Set up, maintained, and supported Oracle, Sybase ASE, Sybase Replication
• Monitored and troubleshooting database problems and errors
• Implemented data model changes wrote custom Perl and Shell scripts for database administration and maintenance