SUMMARY:

• Certified AWS Developer Associate (CDA)
• Certified Oracle Certified Professional (OCP)
• 15 years of IT working experience in software, investment, insurance and banking industries.
• 15 years’ experience on managing high transaction OLTP databases and Large Data Warehouse databases including Oracle, SQL Server, My SQL, PostgreSQL, Teradata,etc
• 15 years’ experience in supporting different ERP applications including Oracle Financials, PeopleSoft, SAP, and many other applications.
• 15 years’ experience in data center operations including cloud computing, grid infrastructure, Exadata server, Linux, Sun Solaris, HP - UX, SCO UNIX, Window NT Server / Clients, SAN Storage and etc.
• 15 years’ knowledge and experience on scripting languages including Shell Scripts, SQL, PL/SQL, Perl, C, C++, Java, Python, XML etc.
• 15 years’ experience on implementing Disaster and Recovery strategies for multiple ERP systems.
• 10 years’ experience on DevOps to automate database deployment, refresh, data migration, upgrade, data replication.
• 3 years experience on cloud computing including Amazon VPC, Route53, ELB, EC2, CloudFront, CloudWatch, Cloud Formation, ElasticCache, Gateway APIs, Lambda, Redshift, AWS RDS, MongoDB, Dynamo DB, Nepture, and etc.
• 10 years experience on Java application development, assurance testing, load testing, user acceptance testing
• 10 years experience on project management methodology with strong oral communication skills and writing analytical skills.

PROFESSIONAL EXPERIENCE:

IT Consultant

Confidential, Malvern, PA

• Meet with business team and application support team to gather requirements, develop appropriate infrastructure solution on deploying web application running on AWS.
• Created virtual private cloud (VPC) and subnets in AWS, setup EC2 instances, configured S3 storages using EBS, etc. Setup and configure ELB and Route53. Setup cloud alert monitoring using CloudWatch.
• Design, develop, implement and build a graph database modeling for a fraud detection application using Neo4j graph database, configured and deployed the database on AWS.
• Migrated on-premise Oracle databases to PostgreSQL databases on AWS using AWS DMS. Migrated SQL Server Database to MySQL database running on AWS. Managed MySQL, SQL Server, Oracle, SQL Server and PostgreSQL databases on AWS.
• Designed schemas, created tables in DynamoDB, deploy dynamo schema & table objects in Cloud, managed and administered DynamoDB running on AWS.
• Using AWS data pipeline to process and move data between different AWS compute and storage services such as S3, RDS, DynamoDB, EMR, etc.
• Designed infrastructure solution and Deployed web application using CLI, SDK, and Cloud Formation.
• Analyzed disaster recovery requirements for web applications, provided high availability solutions by setting up availability zone and auto-scaling group on virtual servers running on AWS.
• Supported large size database environment (more than 100 databases). Managed, maintained, monitored Production database systems and diagnosed performance problems.
• Supported more than 25 application teams as internal clients. Worked with development teams to ensure alignment of development needs and business requirement.
• Provided the support on database issues. Diagnosed and troubleshot the production problems. Resolved the most complex issues to meet client’s satisfaction. Provided the root cause analysis for the incidents.
• Implemented the database migration cross platforms to VM, Exadata, ODA and etc.
• Implemented the major release and deployed database changes in development, pre-production, performance, test and production environments. Provided support and verification on all the stages of the database implementation and related deployments.
• Performed instance tuning, identify slow physical IO, latch contention, excessive CPU usage, etc. Tuned the SQL statements by Explain Plan, ADDM, TKProf, and generated AWR report to identify resource-intensive SQL and diagnose the performance issues.
• Developed and Implemented database encrypted project by protecting application data and implementing TDE encryption on databases.
• Supported and Assisted JAVA application developers on designing, code reviewing, developing, implementing, database connecting, load testing, performance testing, functional testing, and user acceptance testing on developing, upgrading and migrating JAVA/J2EE/JBOss Applications .
• Worked closely with Quality Assurance testers during the testing phase of the project to ensure that any and all necessary changes (fixes or enhancements) to the application can be deployed into the databases and accommodated to meet user requirements and business performance expectation.
• Developed and implemented DevOps tasks including writing scripts to automate database refresh process to meet business requirement and development timeline. Involved with application development teams on DevOps work to make database deployment automation. This DevOps process made the deployment process fast and efficient.

Senior Database Administrator

Confidential, Fort Washington, PA

• Managed, maintained, monitored, and tuned Production database systems and application performance. Lead the data center migration project to migrate Oracle database systems on Legacy platforms to new Oracle 12c database across platforms across data center via different technologies.
• Provided the support on production issues, problems, incidents, etc. Lead the team on diagnosing, troubleshooting the production issues.
• Provided recommendation on database system infrastructure design including platform, operating system, SAN storage, database version based on best practice.
• Installed Oracle 12c grid infrastructure, configured ASM instances, created Oracle 12c databases on exadata machine. Setup Data Guard configuration for standby database on RH Linux system.
• Implemented database auditing, password management, and patch management. Enforced database security based upon best practice, SOX regulations and company policies.
• Created DB Migration plan and performed database migration from old hardware standalone server to new hardware RAC cluster server.
• Provided technical solution to development teamto resolve the client’s issues. And determined the appropriate technical tools to address the client’s need.
• Performed character set conversion to UTF8, converted smallfile tablespace to bigfile tablespace.
• Performed Transparent Data Encryption methodology to accomplish the data security.
• Applied Database CPU and PSU patches periodically in both standalone and RAC environment.
• Improved the performance of the application. Analyze expensive SQL query, identify missing indexes. Fine tune database by changing parameters, adding indexes, partitioning, parallel query, etc.
• Performed real time data replication by GoldenGate, configured and integrated GoldenGate in an Oracle RAC environment, troubleshot replication failures and errors.
• Created physical standby databases, configured and setup Data Guard, switched over to snapshot standby databases and implemented Data Guard switchover and failover during DR test.
• Created DR Test Plans, drove DR tests including SQL Server failover test, Oracle Data Guard switchover test, Data Synchronization component testing.

Senior Oracle Application DBA

Confidential, PA

• Implemented Oracle RAC instances on Linux platform including Software installation, setting up load balancing, and database migration which provide the high availability and scalability for the workflow management system.
• Improved the performance of the application by providing the performance tuning on SQL statements. Fine tune database by changing parameters, adding indexes, partitioning, parallel query and etc.
• Troubleshot, identified and resolved databases related issues. Manage Oracle Service Requests (SRs) to resolution effectively.
• Perform database backup and recovery strategies: developing database backup procedures using RMAN, implementing database refresh, restore and cloning, performing database replication using Shareplex.
• Perform the setup and configuration in Oracle Data Guard, create physical standby database, and implement Data Guard switchover and failover during Disaster recovery.
• Developed PL / SQL programs, SQL scripts and UNIX Shell Scripts / Perl for automation DBA tasks on UNIX environment.
• Performed installation, setup, configure, Rapid cloning, and patching in Oracle EBS 11i. Maintain all instances of the Oracle Application. Maintain security, users, responsibilities, concurrent requests, profile and concurrent manager. Configure and deploy new templates in EBS.
• Worked through the whole project cycle including Plan, Design, Implement, Test, Cutover, and Go Live cycle to upgrade Oracle EBS 11i in 10g on HP-UX system to EBS R12 in 11g on Linux Redhat system.

Oracle Application DBA

Confidential, PA

• Provided maintenance and support on Oracle EBS 11i including installation, upgrading, patching, and cloning.
• Developed performance testing plan and strategies, capacity planning for database systems; identified and analyzed expensive SQL statement.
• Troubleshot production issues; analyzed and diagnosed the problems, ensured each reported problem was resolved by the group in a timely manner.
• Developed generic scripts for regularly hot backup, export, RMAN of different versions of Oracle on UNIX. This helped automation DBA tasks on performing the backup strategies.
• Supported J2EE application running in Oracle 9iAS running on middle tier. Implemented Oracle 10gAS upgrading, setup infrastructure and middle tier configuration.
• Implemented Oracle Portal upgrade project; upgrade portal application from 9.0.4 to 10g Release 2 10.1.2.0.2 in 3 tier architecture.
• Implement application disaster recovery, created physical standby database, performed application failover in Oracle 10g environment, implemented Data Guard switchover and failover during Disaster recovery.
• Developed Enterprise Financial reporting system by setting up Oracle Discoverer for OLAP, installed Discoverer Catalog, built financial multi-dimension cubes and generated financial reports.

Database Developer

Confidential, PA

• Designed and deployed data table structures, forms, reports, and queries.
• Developed and maintained database stored procedures, views and functions for hosted web applications.
• Implemented data dashboards to display data in differing formats.
• Developed, implemented, and maintained change control and testing processes for modifications to databases.
• Conducted research and made recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Identified inefficiencies in current databases and investigated solutions.
• Produced ad-hoc queries and developed reports to support business needs.
• Diagnose and resolve database access and performance issues.
• Applying third party upgrades to existing databases.
• Coordinate and work with other technical staff to develop relational databases and secondary databases.
• Ensured all database systems meet business and performance requirements.
• Created and maintained the technical documentation.