SUMMARY

• An accomplished Principal AWS Cloud Database Solutions Administrator and Architect with more than a decade of experience and focus on database design, database migrations, advanced performance tuning, high performance data replication, backup and recovery, and disaster recovery on AWS RDS & EC2, Aurora, MongoDB, Apache Cassandra, Postgres, Big data, Oracle 12c, 11gR2 RAC, ASM, EXADATA, Data Guard, OEM, Mem SQL, My SQL, dockers and containers, SCRUM. Resolved highly technical and complex database and infrastructure related issues before they impact production and business.
• Proven skills to migrate relational database to AWS and reduce infrastructure and licensing costs by up to 50%
• Proven ability & skills to improve database performance
• Proven skills to quickly troubleshoot and resolve any challenging production impacting issue
• Strong analytical, written, verbal, and presentation skills
• Proven ability to lead, manage and mentor people (lead by example)

TECHNICAL SKILLS

SOFTWARE: AWS, Azure, Postgres, MongoDB, MySQL, Oracle 12c, 11gR2 & 10gR2, 10gR2 RAC, Grid Control, Data Guard, MSSQL, Sybase, Exadata, PL/SQL, Business Objects, KORN SHELL, awk, sedMONITORING TOOLS 11g/12c Oracle Cloud Control, Unicenter, BMC PATROL, PRECISE, TOAD, QUEST, Spotlight

ENTERPRISE BACKUP: RMAN and Legato’s Storage Manager, Tivoli TDP

PROFESSIONAL EXPERIENCE

Confidential

Principal Cloud DBA

Responsibilities:

• Provide database services to Oracle, NoSQL Databases - MongoDB, Cockroach, Big Data, MySQL, MemSQL, Aurora, Postgres, AWS and Azure Cloud to application development on all aspects of database performance issues, patching, upgrade, database tuning, database configuration, database migration, database layout, high availability, disaster recovery, database security - audit vault and vendor interactions in line with corporate objectives using Agile Methodologies - SCRUM
• Experience with Installation, Upgrades and configuration
• Experience with migration of existing Oracle, SQL Server Databases to AWS
• Design complex solutions which integrate AWS cloud, on premise physical and Virtual server, EC2, S3 storage, networking and security. Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions.
• Tuning and troubleshoot database applications and provide support to users and clients
• Enrolling, Controlling and Monitoring user access to database
• Identify opportunities for reorganization of tablespaces, tables and indexes as fragmentation occurs
• Managing schema objects - database links, procedures, packages, triggers, sequences
• Architected both Infrastructure and Database Resilient Solutions for Critical Applications running on Oracle
• Implement Database Backup Strategies and Disaster Recovery solutions for existing Projects with respect to mean time to recover. Specific strategies include implementing flashback database, tablespace point in time recovery for recovering purged objects
• Experience in tuning/AWR/ADDM and monitoring tools like OEM.
• Automate DB tasks using scripting languages (PL/SQL, Ksh, Bsh, Csh) and Ansible
• Analyze on premise database environments such as DB2, Oracle, SQL Server, MySQL and/or Postgres, evaluate and plan migrations to AWS RDS, Aurora
• Develop/Enhance database PLSQL scripts to migrate from source database to target database
• Identity workarounds for specific issues and corner scenarios observed during migration
• Automate solutions for repeatable problems • Develop test plan and testcases to demonstrate database readiness post migration • Work closely with application teams to ensure business functionality and SLAs are metHelp design and implement AWS RDS and Aurora architectures and configurations for customer • Work closely with AWS RDS, Aurora, DMS and SCT tools to help ensure the success of project consulting engagements with customer • Consult for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance • Develop innovative solutions to complex business and technology problems • Conduct technical sessions for internal teams, partners and customers Qualifications • 10+ years of experience in database development/migration using PL/pgSQL • Must have development experience on Oracle 5+ years hands-on experience on PostgreSQL • Experience with databases of 1-10TB in size across multiple database platforms (e.g. PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, etc.) • Experience with heterogenous database migrations from one database engine to another • Experience in performance optimization techniques • Bachelor’s degree in Computer science or equivalent • AWS Solutions Architect Certified • High end Troubleshooting and Communication skills • Scripting language (bash, Perl, python) • Experience in Database Administration - backup/restore, replication, etc. • Experience in ETL workflow managementExperience in non-relational databases - DynamoDB, Mongo, etc. • Experience in MPP data warehouse solutions - Redshift, Greenplum, etc

Confidential

Sr. Oracle DBA

Responsibilities:

• Developed and implemented a technically challenging solution to migrate & consolidate two 15 TB 10g databases to Linux using 11gR2 RAC-ASM, DataGuard, Linux with SGA size of 420GB and a very complex custom innovative procedure utilizing many shell scripts, Datapump jobs, concurrent parallel index rebuilds and gather stats for over 1000+ objects in under 10 hrs. and saved the company millions of dollars.
• Architected migration of SQL server databases using backup and restore, copy database wizard using SQL server Management Studio and generate the create script using generate Script Wizard(SSMS).

Confidential

Sr. Oracle DBA

Responsibilities:

• Provide leadership in the design, architecture of corporate large scale Oracle database infrastructures with a focus on innovating ways to reduce overall database footprint through Host consolidation on x86 hardware architectures - EXADATA, CISCO UCS Blade Server 11gR2 RAC, Instance Caging, IO Resource Manager, LPAR and isolation through Oracle Instance Caging, Oracle VM, VMWare that increases ROI, reduces TCO and meets the upcoming demand
• Lead, manage and completed EXADATA implementation. Key tasks included measuring and validating database performance and code scalability using Benchmark Factory(BMF), migrating current database to Quarter/Half Rack.
• Lead and coordinate the remediation of database audit points, infrastructure security compliance, SOX and DBMS exception process and resolutions to ensure continuing compliance against audit points and policies, and to prevent repeat audit points.

Confidential

Sr. Oracle DBA

Responsibilities:

• Provided on-going Support to Global Wealth Management (GWM) Single Client Profile (SCP) and Hub Online Projects using Oracle 10gR2 on Sun Solaris 5.10 and Siperian MDM (Master Data Management) Hub with over 3TB of data and 18 Database instances supporting release trains like Dev, SE, IDE, QA, UAT, and Production database environments.
• Architected and implemented the development of distributed, redundant, recoverable database architecture for Confidential ’s Orchestra Active Policy Management (APM) system using Oracle 10gR2 RAC on LINUX Red Hat 4.0.
• Analyzed and Proposed Database Backup Strategies and Disaster Recovery solutions for existing Projects with respect to mean time to recover. Specific strategies include implementing flashback database, tablespace point in time recovery for recovering purged objects, VCS clusters for node failures and EMC SRDF solution for Disaster Recovery. Provide consultancy in planning & implementation of Database Backup and Disaster Recovery solutions for new projects. Evaluate the feasibility of making Database Backup Strategy and Disaster Recovery part of the infrastructure for all new projects.
• Developed and implement best practices and standards for database support activities. Provide technical consulting services to other departments wishing to exploit RDBMS platforms.
• Provided technical consulting services to application development and systems areas on topics relating to database performance, database enablement technologies, database server environmental configuration, and data access issues.
• Capacity Planning Lead for Oracle Managed Services - Responsible for the ongoing delivery and execution of oracle managed service solutions effectively and efficiently within DBMS Application environments as well as the ongoing maintenance to ensure availability, reliability, supportability and manageability. .
• Architected and provided a solution to manage current large volume of metadata within the RMAN catalog database with over 300+ database and be able to recover full production database in disaster recovery scenario within Service Level Agreement.
• Implemented Sarbanes Oxley audit and security procedures