Database Administrator
Resume:
Vamsi Parna
***********@*****.***
Summary:
An accomplished technology professional with over 15 years of experience encompassing infrastructure management, database administration, people leadership, technology optimization, and the creation of innovative software solutions tailored to meet specific needs. Proficient in automating processes to reduce costs, with a strong track record in facilitating teamwork, conducting problem analysis, troubleshooting issues, and demonstrating exceptional prioritization skills. Equally adept at excelling as an independent contributor and collaborating effectively within a team.
Technical Skills:
Databases: Oracle, PostgreSQL, MySQL, MongoDB, AWS RDS, Aurora (PostgreSQL/MySQL), DynamoDB
Cloud and DevOps: Amazon Web Services (AWS), Oracle Public Cloud, Google Cloud Platform (GCP), PDS, Flash DB, Kubernetes, Git, Maven, Jenkins, Selenium, Ansible, Nagios, Chef, Docker, Terraform
Cloud Services: IaaS, PaaS, SaaS, Private/Public/Hybrid Cloud, DBCS, DbaaS, ExaCS, OCI, Bare Metal, Lift & Shift, Cloud Storage Services, REST API, Pivotal Cloud Foundry
Operating Systems (O.S): Solaris, AIX, Red Hat, HP-UX, Windows, Ubuntu, Amazon Linux
Servers/Storage: Exadata, Exalogic, Oracle Database Appliance (ODA), Sun Sparc V880, HP ProLiant, Intel Xeon, Fujitsu Prime Power, IBM Power7, NAS, SAN, NetApp, NFS, CIFS, SRDF, LPAR, LVM
Domains: Financials (Trading, Investment Banking, Trust, Corporate Applications, Institutional, BOS), Manufacturing, Automobile, Insurance, Healthcare, Hospitality, HRMS/HCM, CRM, EAM, SCM, Logistics, WMS, Leasing
Scripting and Tools: Shell scripting, YAML, PERL, JSON, GIT, Python, Visio, SharePoint, Tivoli, PEM, JIRA, Confluence, MS Projects, NetBackup, Networker, SSH Keys, CMDB, Puppet, Postman, Splunk, Fog light
Application Servers/Reports: Discoverer, WebLogic, Oracle Application Server, OBIEE, Single Sign-On (SSO), Oracle Identity Manager (OIM), Oracle Access Manager (OAM), Oracle Internet Directory (OID), Tomcat, Apache, OAuth, Open ID Connect
Data Protection and Replication Tools: Vormetric Encryption, Avamar, Commvault, RMAN Encryption, PGP, GPG, Snap Clone, Backup Exec, Data Guard, Shareplex, Delphix, Oracle Advanced Replication, SSH tunneling, Digicerts, Verisign, Tape Restores, DMZ, Golden Gate, Imperva, Wallets, Data Masking, Data Encryption, Qualys, Venafi, SSL/TLS, Barman, REPMGR, AD, LDAP, Liquidbase, Fireway
Operating Tools: Remedy, CCB CAB, JIRA, Solar Winds, Clear Case, Autosys, i3, Perceiver, AppDynamics, Oracle Enterprise Manager (OEM) 13c, OS Watcher, VAL (Virtual Application Layer), Alarm Point, TFA, Xmatters, Archer, Moogsoft
Work Experience
TD Ameritrade 01/2014- Present
Oracle / Oracle Apps Responsibilities
Future-Ready Oracle EBS Applications: Designed the blueprint for future-state applications within Oracle EBS, involving architectural redesign for R12.1.3, meticulous hardware sizing, robust disaster recovery solutions, and comprehensive backup and recovery strategies.
Comprehensive Enterprise Management: Oversaw the management of enterprise applications and systems, spanning Oracle eBusiness Suite R12, Databases, PeopleSoft, and Back office domains.
Lead DBA Responsibilities: As Lead DBA, assumed leadership for E-Business Suite 12.2.2 Data Guard implementation, Data Center migration efforts, and day-to-day support operations. Collaborated closely with clients to ensure seamless installations and go-lives, delivering training to empower team in managing Oracle products and environments. Maintained a swift response to address critical issues that could impact the production environment
Strategic Upgrade Initiatives: Strategically planned and executed the upgrade of TDA Production applications from R12.1.3 to R12.2.4, leveraging 12.1.0.2 (12c) databases.
Oracle Production Database Expertise: Held responsibility for the end-to-end implementation, administration, and support of Oracle production database systems. This encompassed tasks such as CPU/PSU patching, optimization, reliable backup and recovery processes utilizing RMAN, the creation of scripts to schedule Oracle PL/SQL procedures, and adept troubleshooting.
Database Administration Excellence: Demonstrated expertise in various Database Administration tasks, including installation, database creation, robust backup and recovery strategies, intricate performance tuning, and diligent capacity planning, generated daily reports, escalations and involved respective teams.
Day-to-Day Database Management: Managed the day-to-day aspects of database administration, including capacity planning, expert troubleshooting, precise debugging, and continuous efforts in performance tuning.
High Availability Implementation: Established and meticulously maintained a High Availability (HA) environment. Conducted routine annual disaster recovery exercises and skillfully simulated diverse disaster scenarios to validate the effectiveness of recovery objectives. Ensured compliance with SOX requirements in this regard.
PostgreSQL Responsibilities
Strategic Leadership: Influential in shaping the overall database engineering strategy by collaborating with vendors, architect’s technical experts and management. Demonstrated proficiency in serving as a technical leader, aligning application strategies with the database strategy through roadmap creation in collaboration with application program leadership.
Technology Integration: Efficiently developed technology roadmaps and offered expertise for seamlessly integrating technologies and platforms into existing PostgreSQL environments.
Database Excellence: Constructed highly available, scalable, and efficient PostgreSQL database solutions while adhering to rigorous standards and security protocols.
PostgreSQL Proficiency: Accomplished in a wide range of PostgreSQL tasks, including installation, configuration, replication (physical/logical), standby read replicas, backup and recovery, performance optimization, vacuuming, auditing, privilege management, upgrades (major and minor), extensions, foreign data wrappers, debugging, and troubleshooting.
Disaster Recovery and Compliance: Developed robust disaster recovery (DR) and high availability (HA) plans and executed planned DR activities. Ensured compliance with SOX and PCI standards to safeguard sensitive data in production databases.
MySQL Responsibilities:
MySQL Administration: Installed and configured MySQL databases, established backup procedures, implemented master/slave databases for high availability, managed restore and recovery processes, oversaw database refresh tasks, handled space management, conducted runtime performance tuning and troubleshooting, managed user creation and privilege granting, and ensured robust security management.
Managed MySQL Master/Slave DB Cluster: Built and maintained a MySQL Master/Slave database cluster spanning across four datacenters. Configured Multi-DC replication and automatic failover to ensure high availability and disaster recovery capabilities.
Database Cloning and Maintenance: Conducted cloning and refreshing of non-production databases, managed schema changes, performed daily database administration tasks, monitored space usage, and ran reporting processes to support operational needs.
Migration to AWS RDS: Successfully performed the migration of MySQL databases from on-premises datacenters to AWS RDS (Relational Database Service) as part of a Lift and Shift initiative.
Comprehensive Support: Provided comprehensive support for development, QA, and production MySQL instances and databases to ensure optimal performance and reliability.
Storage Engine Migration: Demonstrated expertise in migrating databases from the MyISAM storage engine to Innodb for enhanced performance and improved integrity constraints.
Performance Enhancement: Significantly improved database performance through strategic MySQL configuration changes, deployment of multiple instances, and hardware upgrades.
MongoDB Responsibilities
Mastery of MongoDB Lifecycle Management: Proficiently managed the entire lifecycle of MongoDB, encompassing tasks such as installation, upgrades, meticulous capacity planning, automation, vigilant monitoring, adept troubleshooting, and precise performance optimization.
Responsible for MongoDB Cluster Maintenance: Accountable for the seamless maintenance of MongoDB clusters, which involved activities such as node management (additions and removals), precise job scheduling, vigilant cluster monitoring, meticulous capacity planning, and the diligent management and review of backup and log files.
Effective Deployment of Ops Manager: Successfully deployed Ops Manager to streamline monitoring, facilitate alerting, and enable automation, ensuring it remained consistently updated with the latest releases.
Expertly Designed High-Availability MongoDB Clusters: Demonstrated expertise in the design, configuration, and implementation of high-availability MongoDB clusters. These clusters utilized multi-shared replica sets, were distributed across multiple data centers, and spanned both physical and virtual nodes for optimal performance and resilience.
Cloud DBA (AWS/Oracle Public Cloud/GCP)
Close Collaboration for Cloud Database Strategy: Worked closely with Enterprise Architecture, IT strategy, and Development teams to collaborate on shaping cloud database strategies. This included establishing roadmaps, defining design standards, and overseeing implementation efforts.
Optimal Database Configuration: Actively participated in design sessions for new workloads to ensure the implementation of optimal database configurations.
Efficient Database Provisioning: Implemented the automation of database provisioning using the RDS CloudFormation Template (CFT) for increased efficiency.
Innovative Technology Research: Proactively conducted research on emerging technologies and explored innovative solutions to align with evolving business requirements.
Database Capacity Planning and Budgeting: Led efforts in database capacity planning and budgeting exercises, ensuring the effective allocation of resources.
AWS Infrastructure Deployment: Orchestrated the deployment of EC2 instances, configured PostgreSQL clusters, and established AWS Aurora PostgreSQL/MySQL databases as part of cloud infrastructure setup.
Proficiency in AWS Services: Demonstrated expertise in configuring and managing various AWS services, including EC2, S3, VPC, CloudWatch, CloudFormation, Cloud Trail, Lambda, Route 53, Load Balancers, IAM (Identity and Access Management), and Roles.
Large-Scale Database Migrations: Successfully designed and executed large-scale database migrations, transitioning from on-premises environments to the cloud with precision and effectiveness.
Work Summary:
Management Consultant / Senior Database Architect at TUSC Apr 2010 to Dec 2013
Senior Database Administrator at Wachovia Bank Mar 2006 to Mar 2010
Consultant at Hyatt Hotel Corporation Mar 2004 to Feb 2006
Consultant at State Street Bank & Financial Corporation Jan 2003 to Oct 2004
Applications/Database DBA at VERITAS Jan 2000 to Dec 2002
Certifications:
Amazon Web Services (AWS) Certified Solution Architect
Cloud Security Knowledge Certificate (CCSK)
Certified Professional in Oracle Database Cloud Administration
Certified in Oracle eBusiness Suite (R12) Application Database Administration
Oracle Certified Professional (OCP) in Database Administration for 12c and 11g
Education:
Master of Sciences in Computer Sciences, Sri Venkateswara University, India
Contact this candidate