Home

Phaneendra VNV - Oracle DBA

[email protected]

Location: Remote, Remote, USA

Relocation: Yes

Visa: H1B

Richmond, VA Professional Summary Accomplished Database Administrator with over 15 years of hands-on experience in managing and optimizing complex database environments, specializing in Oracle (19C, 12C, 11g, 10g, RAC) and MS SQL Server (2012-2019). Demonstrated expertise across Finance, Banking, and Healthcare sectors, delivering robust solutions for high availability, performance optimization, and disaster recovery in mission-critical systems. Adept at leading large-scale database migrations, upgrades, and automation projects across diverse platforms, including Linux, Solaris, AIX, HP-UX, and Windows. Proficient in AWS Cloud services with knowledge of PostgreSQL, MongoDB, and Cassandra. Known for a strategic approach to problem-solving, comprehensive technical knowledge, and commitment to maintaining operational excellence in 24x7 environments. Certified Oracle DBA and AWS Solutions Architect with a track record of successful project delivery and team leadership. Strong database administration across Oracle and SQL Server environments Expertise in database upgrades, high availability (RAC), disaster recovery (DataGuard), and GoldenGate replication Extensive experience with Exadata, ASM, OEM, and automation through scripting Strong performance analysis using AWR, ADDM, SQL Profile, ASH, and advisory views Experience with OS, storage, network, and virtualization activities Experience with ITIL tools such as Remedy, ServiceNow for Service Request and Incident, Problem, Change management Configuration, capacity planning, and knowledge management Identifying and implementing service improvement plans Core Components Database Technologies : Oracle (19C/12C/11g/10g, RAC), MS SQL Server (2012-2019), PostgreSQL, MongoDB, Cassandra, MySQL Database Tools : Oracle Data Guard, RMAN, OEM, GoldenGate, STATSPACK, AWR, ADDM, TOAD Cloud Services : AWS (EC2, RDS, S3, EBS, ELB, Auto Scaling) Operating Systems : Linux, Solaris, AIX, HP-UX, Windows Performance Tuning & Optimization | Disaster Recovery | High Availability Systems | Data Migration | Automation & Scripting Awards / Accomplishments STAR of the month award from the client (Best Buy) Multiple monetary celebrating Performance points Company appreciation for best performance Outstanding contribution award from the client (Kaiser Permanente) Certifications Oracle 9i Database Administrator Certified Professional Oracle 10g Database Administrator Certified Professional Oracle Database 12C Administration AWS Certified Solutions Architect Associate Academic Details Master of Computer Applications (M.C.A) from Osmania University (2004-2007) Bachelor of Science (B.Sc.) Computers from Nagarjuna University (2001-2004) Professional Experience Technical Systems Architect, ATEK IT, Inc June 2024- Till date Client: ROH Technologies, Columbia, South Carolina Installed and configured Oracle software and created databases tailored to business needs. Performed regular upgrades to ensure databases and related software were up to date with the latest releases. Managed storage structures, ensuring optimal performance and scalability. Administered user access and security, implementing best practices for database security and compliance. Managed schema objects, including creating and maintaining tables, indexes, and views. Led backup and recovery efforts, ensuring data integrity and minimal downtime during critical operations. Conducted regular server maintenance, patch evaluations, and installed necessary patches to maintain stability and security. Diagnosed and resolved complex issues related to Hyperion infrastructure, ensuring seamless operations. Communicated effectively with Engagement Managers and technical teams, providing regular updates and escalating issues as necessary. Led client engagement workstreams focused on process improvement and optimization, implementing leading practices and driving operational outcomes. Successfully led major database upgrade projects with minimal downtime. Spearheaded the implementation of leading practice workflows, significantly improving operational efficiency. Resolved critical Hyperion infrastructure issues, ensuring uninterrupted service for key business applications. Provided 24x7 on-call support for critical database environments, ensuring high availability. Technical Lead, Cognizant Sep 2015 June 2024 Clients: Kaiser Permanente (US) & Change Health Care (US), Novartis Directed a team of 20 in the administration and optimization of Oracle 11g/12c/19c, SQL Server, PostgreSQL, MongoDB, and Cassandra databases for multiple high-profile clients. Managing and optimizing large database estates, handling TB-sized databases across multiple Unix platforms and Windows servers. Spearheaded installation, configuration, and administration of multiple database versions, including high-availability solutions (RAC, GoldenGate, DataGuard). Managed and administered databases on Exadata machines, ensuring optimal performance and availability. Planned and executed major migrations, upgrades, and patching, minimizing downtime and ensuring data integrity. Implemented and managed ASM instances, defining and troubleshooting disk and disk groups. Coordinated with database vendors to resolve major incidents and provided 24x7 on-call support for critical applications. Installed and managed Oracle Grid Control for database monitoring and performance tuning, including defining performance benchmarks and periodic reviews. Developed and maintained Standard Operating Procedures, contributing to tool evaluations, and providing technical guidance to L2 and L1 DBAs. Proactively identified and mitigated risks, implementing automation and security measures to enhance database operations. Spearheaded large-scale database migrations, upgrades, patching, and maintenance activities, ensuring minimal downtime and high data integrity. Designed and implemented robust backup & recovery strategies using RMAN and Data Guard, achieving near-zero RTO/RPO. Enhanced system performance and availability by leveraging Oracle RAC, Exadata features, and advanced performance tuning techniques. Provided 24x7 on-call support, ensuring uninterrupted service delivery for mission-critical applications. Played a pivotal role in maintaining detailed documentation, standard operating procedures, and disaster recovery plans. Expertise in Oracle Enterprise Manager (OEM), managing RAC environments, performance tuning, and troubleshooting. Administered Oracle Exadata environments, including setup, configuration, and maintenance. Managed and optimized Exadata storage cells and database servers to ensure high performance and availability. Implemented Exadata features such as Smart Scan, Hybrid Columnar Compression, and Storage Indexes for performance optimization. Conducted regular patching and upgrades of Exadata components to ensure compliance and security. Performed capacity planning, storage management, and performance tuning in Exadata environments. Ensure Rubrik is set up to perform consistent and reliable backups of Oracle databases. Use Rubrik to perform database restores and recoveries when necessary. Resolved/Diagnosed Node Eviction. Manage RAC environment for Day-to-Day Database administration and performance Tuning. Migration of databases from NON-RAC to RAC. Converting Physical standby databases to Snapshot standby databases. Cloned databases using RMAN and Manual techniques. Performed database maintenance activities for production environments. Technology Analyst, Infosys Jan 2013 Aug 2015 Project Title : Capital Group Companies (CGC US) Environment : Oracle 11g, Sun Solaris, Sybase, SQL Server 2008/R2 Role : Sr. Oracle Database Administrator /Sybase Admin Team Size : 23 Supported Oracle 11g databases for Capital Group Companies (US) in a 24x7 environment. Managed database refreshes, migrations, and capacity planning. Provided 24x7 production support for both Production and Development databases as L2-Oracle-Support. Performed database refresh using RMAN backup, cold backup (physical files), schema and tables using Data Pump. Managed database migrations, upgrades, and patching. Conducted capacity planning, including individual object growth and space consumption analysis in tablespaces. Scheduled backup policies and validated backups for all databases. Installed Sybase clients on Unix/Solaris OS and Oracle clients on Windows/Unix/Linux servers. Managed database refreshes, migrations, and capacity planning. Supporting Production and Dev databases in 24x7 Environment as L2-Oracle-Support Database refresh using RMAN backup or cold backup (physical files), schema and tables using Data Pump Database migration, Upgradations and patching as per requirement. Capacity Planning: Individual objects growth, space consumption in tablespace and estimate DB growth. Schedule Backup policies for databases as per requirement, ensure backups are valid for all Databases. Associate, Accenture Aug 2009 Dec 2012 Project Title : Best Buy Client : Best Buy US / CANADA Environment : Oracle 9i/10g/11g RAC, Linux, Solaris and UNIX. Role : Oracle Database Administrator Team Size : 20 Oracle Database Administrator for Best Buy (US), supporting Oracle 9i/10g/11g RAC. Managed tablespaces, backups, database upgrades, and performance tuning. Provided 24x7 L2-Oracle-Support for Production and Development databases. Administered physical files of the database, including creation and maintenance of tablespaces, resizing the database, and configuring listener/shared server configurations. Managed user accounts, roles, system privileges, and quota maintenance for schemas. Monitored and addressed alert log errors, applied patches on clusters and databases, and performed database upgrades. Conducted database export/import activities for tables, tablespaces, and entire databases. Monitored standby database status and scheduled alerts for tablespaces, backups, and disk usage. Monitoring scheduled database alerts (Tablespaces, Backups & disk usage) Monitoring standby database status Keywords: user experience sthree database information technology hewlett packard microsoft South Carolina Virginia