Arun Kumar Nampally
Cumming,GA
Summary
Accomplished Cloud Database Engineer and DB Automation Engineer with over 10 years of expertise in database administration and the development of robust on-premise and cloud-based solutions. Proven track record in optimizing database performance, enhancing data security, and driving strategic initiatives that support organizational growth. Exceptional communication and presentation skills facilitate effective collaboration across teams. Committed to leveraging advanced OnPrem and Cloud technologies to deliver innovative database solutions.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Database Engineer/DB Automation Engineer
Fannie Mae
Reston, VA
05.2016 - Current
- Managed AWS database services like EC2, S3, EBS, VPC, Amazon RDS, Amazon DynamoDB, Amazon Aurora.
- Involved in managing database deployments, configurations, and upgrades in AWS cloud environment.
- Involved in monitoring database performance and implementing proactive measures to prevent downtime.
- Experience using CloudWatch in monitoring AWS services.
- Automate routine database tasks using AWS Lambda, AWS CloudFormation, and other AWS services.
- Implement Infrastructure as Code (IaC) for database deployments Migrated current Linux environment to AWS EC2/RDS.
- Monitor and optimize database costs by selecting appropriate instance types and storage options.
- Use AWS Cost Explorer and Trusted Advisor for cost management and optimization.
- Experience using DMS (Database Migration Service) and SCT(Schema Conversion Tool) to migrate databases from on-premises to AWS Cloud EC2 and RDS (Oracle and Aurora PostgreSQL).
- Experience using DMS (Database Migration Service) for ongoing data replication. (Homogeneous & Heterogeneous Environment).
Database Administrator
Merck KGaA (EMD Millipore)
Bedford, MA
10.2014 - 04.2016
- Created and maintained all databases required for development, testing, education, and production usage.
- Installed, configured, and maintained Oracle 2-Node Real Application Cluster.
- Performed the capacity planning required to create and maintain the databases.
- Worked closely with system administration staff because operating systems often have applications or tools on them, in addition to the Oracle databases.
- Performed ongoing performance tuning of the database instances.
- Performed the upgrade of databases from 11.2.0.2/11.2.0.3 to 11.2.0.4/12c, and applied the PSU and CPU patches required to make the ORACLE HOME up to date.
- Installed new versions of the Oracle RDBMS, its tools, and any other tools that access the Oracle databases.
- Implemented backup and recovery of the Oracle database.
- Involved in managing daily online backups (Level-0 and Level-1) and archive backups using RMAN by 12c Cloud Control and Grid Control.
- Controlled migrations of programs, database changes, reference data changes, and menu changes through the development life cycle.
- Cloned and restored databases for QA and development environments from production environments using RMAN (Recovery Manager) duplicate and restore.
- Performed monthly and quarterly data refresh from production to development and test environments using Data Pump export/import.
- Implemented and enforced security for all of the Oracle databases.
- Performed database reorganizations as required to assist performance and ensure maximum uptime of the database.
- Used the HP Service Manager (HPSM) ticketing tool for monitoring the incidents and service requests.
- Provided 24/7 production support, as I was always on call for maintenance activities.
Education
Master of Science - Computer Science
Troy University
Troy, AL08-2012
Skills
Database Versions: Oracle 19c, 12c, 11g, and 10g
Oracle Product: Oracle Real Application Cluster (RAC) 11g/12c, OEM 12c/13c, Goldengate, Data Guard, Import and Export, Data Pumps, Data Masking, Oracle Wallet Management, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control), Oracle Exadata, RMAN, Transparent Data Encryption
Cloud Technologies AWS, Azure
Operating System: Oracle Linux, RHEL 7, AIX, SOLARIS
DevOps Tools Jenkins, Terraform
Selected Highlights
- Migrated hundreds of Oracle and PostgreSQL databases from on-premise into the Cloud. In order to accomplish
that goal in time record I established a process to deploy using infrastructure as code (CloudFormation) with
automation tools (Jenkins).
• Experienced in using Jenkins tool to eliminate repetitive and manuals processes for the provisioning of hundred
servers & databases on an IaaS and PaaS model. All those activities were done using a DevOps framework and
practices which allow the team to deliver databases and infrastructure quickly, conduct proof of concept & proof
of value of new technologies to transition from on premise datacentre to a hybrid & Cloud environment.
• Worked with the business to architect and design solutions that leverage the use of latest capabilities related to
cloud database technologies.
• Involved in planning and installing new Oracle databases, space monitoring, ensuring the competition of backups,
restore of databases in case the customer required, implementation of different control points for the backups,
design and installation of high availability environments, performance analysis and support 24/7 on-call service,
participate in Disaster Recovery scenarios, and defined standard and policies for the daily tasks.
• 5+ years of hand-on experience in using AWS Services like EC2, RDS, SNS, S3, EBS, CloudFormation, Route53, DMS
(Database Migration Service).
• 5+ years of Experience in migrating oracle databases to AWS Aurora PostgreSQL.
• 10+ Years experience in Oracle 12c & 19c Goldengate Implementation.
• 4+ years of hands-on experience as a Snowflake Database Administrator.
• Led a team of 7 core and application DBAs, responsible for the day-to-day operations.
• Extensive knowledge on database administration for Oracle 19c, 12c and 11g- with experience in very large-scale
database environment and mission critical large OLTP systems.
• Experienced in Oracle 19c, 12c and 11g RAC implementation & administration (Oracle Clusterware setup and
configuration- RAC installation using ASM- Grid Installation).
Certification
- AWS Solution Architect Associate
- Terraform Associate
Timeline
Database Engineer/DB Automation Engineer
Fannie Mae
05.2016 - Current
Database Administrator
Merck KGaA (EMD Millipore)
10.2014 - 04.2016
Master of Science - Computer Science
Troy University
Similar Profiles
VENKAT CHITTEPUVENKAT CHITTEPU
Sr. Product Manager - Finance Technology at Fannie MaeSr. Product Manager - Finance Technology at Fannie Mae
Moses Judson Edward Sundaram Ananthajothi BalanMoses Judson Edward Sundaram Ananthajothi Balan
Senior Technical Architect at Fannie MaeSenior Technical Architect at Fannie Mae
MARCUS COLEMARCUS COLE
Director, Program Management, Strategic Partnerships & Workforce Strategy at Fannie MaeDirector, Program Management, Strategic Partnerships & Workforce Strategy at Fannie Mae