Oracle Dba Database Administrator

.

.

+1-510-***-**** **.***********@*****.*** Oracle Database Administrator 19c OCP Certified

SANKAR VEJALLA

SUMMARY

A seasoned Senior Database Administrator with over 16+ years of experience, specialising in Oracle administration across various platforms and industries such as Financial Sector and Healthcare. With long-standing experience at the Bank of America, managing the production databases, I have deeper sense of understanding on Federal security standards, policies that were implemented. Being a senior DBA, provided expertise to continuously adopted best practices and implemented standards to safeguard the public data. Worked with various product and business owners to understand the ongoing policy changes, and enhanced data retention policies to limit the active data storage for faster retrieval. Involved in building and expanding data warehouse environments for research and reporting use of Bank of America internal and external users. As production support DBA, provided 24x7 on-call support for diversified databases at BOA. I have continuously enhanced my skills in database administration, specializing in Oracle versions 9i to 19c and focusing on large-scale OLTP and OLAP database environments. Proficient in tasks such as Oracle installations, upgrades, migrations, SQL tuning, and security implementations, including data encryption. Additionally, I have developed expertise in DBaaS technologies like Exadata and expanded my knowledge to include innovations such as Snowflake, PostgreSQL, and AWS services. I excel in managing projects from start to finish to meet business needs and improve client relationships. My foremost priority is ensuring data security, including the proper handling of PII and sensitive financial information throughout different project stages. I thrive in collaborating closely with business and product stakeholders, carefully evaluating scalability for future growth, documenting requirements, and executing strategic modifications to enhance organizational effectiveness.

EXPERIENCE WITH TOOLS & TECHNOLOGIES

Cloud/Data Services AWS EC2/RDS/IAM/S3, GitHub

DBMS / RDBMS Oracle 8i, 9i, 10g, 11g, 12c,19c, Oracle OCI, PostgreSQL, Snowflake Operating Systems Windows, Sun Solaris 8,9,10, HP-UX 10.x, 11.x, RHEL 3.x, 4.x, 5.x, 6.x,7.x 8.x Markup/Scripting Languages PL/SQL, UNIX Shell Scripting. Python (Knowledge) Monitoring/GUI IPCenter, OEM, Precise, Patrol, foglight, RMAN, NetIQ, CyberArk, Hashicorp password Vault,Tivoli,Team Quest, Tableau, Toad, Putty, HPDMA, DLA, Datical,Radical, Tuning Tools TKPROF, EXPLAIN PLAN, AWR, Tuning Advisor, Ticketing Tools JIRA, ITSM, IPCenter, Nexus, BMC Remedy, Maximo, ServiceNow EDUCATIONAL QUALIFICATIONS

Master’s in computer applications from Andhra University, India

Bachelor’s in computer applications from Acharya Nagarjuna University, India PROFESSIONAL SUMMARY

Senior Database Engineer (Feb 2024 to till date)

Stockton Drug Inc,Galt Pharmacy, Galt CA.

Role & Responsibilities:

Analyse and understand the business goals of the data layer in the pharmacy application by hosting series of knowledge gaining, and brainstorming sessions to get better understanding of the current environment.

Identifying and documenting the Pharmacy group pain points, and challenges currently encountered with the data.

Conducting thorough analysis of existing databases, identifying areas for improvement, and recommended necessary changes based on the industry best practices, data retention policies, and pharmacy regulations.

.

.

+1-510-***-**** **.***********@*****.*** Oracle Database Administrator 19c OCP Certified

Focused on Enhancing data security by conducting audits, monitoring access controls, and identifying stale accounts.

Analysing user access levels across database users, including admins, making tighter controls to protect important data related to various programs data.

Implementing role-based access controls and data encryption/masking measures, ensuring the security and protection of sensitive data.

Identified performance issues, optimizing query performance through proper indexing strategies, other tuning techniques, tuning packages resulting in faster response times from applications which helped business users to complete their day-to-day data analysis and the reports to management and marketing teams .

Configured and Maintained Oracle RMAN/Expdp Backups, which include full, incremental, and Database recovery strategies. Make sure backups are running as per the schedule.

Identified and applied some critical patches for product features and security fixes across all environments from Sandbox/Development to Production.

Reviewing existing databases, analysing the data flow, and data retrieval efficiencies by removing the calls for redundant data. Bank of America, 15+ years with various roles and responsibilities. Technology Services Lead (Individual Contributor) (Mar 2018 to Dec 2023) Role & Responsibilities:

Integral part of the Senior DBA team supporting Global Wholesale Banking, Global Corporate and Investment Banking. Working on business aligned projects, BAU.

Key Projects: Very Large Databases (VLDB) migrations from legacy to Exadata private cloud (DBaaS). Data Center exit programs. Performance tuning projects for mission critical payments applications. Collaborated with other DBAs and Business Owners, led the data warehouse design, development, testing and implementation efforts for BoA investment banking. Designed and developed automation for routine DBA tasks, complex archiving/purging solutions, Goldengate HA architectures on RAC/Standalone providing automated custom site switchover and failover. Experience with financial data and a good understanding of government policies and regulations on financial data and security standards.

Acted as the go-to expert on databases for several migration and upgrade projects, transitioning from 11g/12c to 19c on non-Exadata to DBaas Exadata platforms. Oversaw the entire project lifecycle, resulting in a 50% increase in processing speed and a significant reduction in hardware costs.

Experience on Oracle Database Migration from On-premises to AWS EC2/RDS using Expdp/Impdp Transportable tablespace and RMAN.

Expertise on Oracle ASM, Grid, Datagaurd, RAC 11g/12c, Private Cloud DBaaS (12.x,19.x), Exadata X6-2, Oracle OCI, Oracle Golden Gate 12c and 19c.

Oversaw Oracle RMAN backups, including full, incremental L0/L1, and database recovery strategies. Ensure that backups run according to the established schedule, facilitating refreshing of lower-level databases as needed.

Establishing and managing databases for development, quality analysis, and production purposes

Managed the migration of 20TB of critical data to a new distributed database system, achieving the project goals 1 month ahead of schedule and with zero data loss. Implemented new data retention strategies based on the new policies and standards.

Proficient in managing high-volume transaction processing, handling thousands of client interactions per minute including website browsing, data updating, and event participation.

Before rolling out changes to the production environment, it is essential for a database administrator (DBA) to work closely with the application team. This collaboration involves code review, query optimization, and performance enhancement for public end-user applications utilizing faster implementation techniques such as Scrum and Agile methodologies.

Using GitHub and Jenkins in conjunction optimizes the database release process, enabling the creation of a streamlined workflow for version control, automated testing, and continuous delivery of database changes. This integration promoted and improved efficiency, transparency, and reliability in managing database configurations and updates.

Participated in business processing reengineering sessions with investment banking stakeholders, assessed their goals, and documented requirements. Worked with DBA team and reporting analytics group in data warehouse design, build, test and implementation by following SDLC standards, using Agile Scrum methodologies. Supported the Business Intelligence team in supplying the data for report generation.

We utilized Jira to create tickets and integrate with Scrum and Agile methodologies, leading to streamlined workflow and increased productivity. This approach enabled successful outcomes in the fast-paced IT environment.

Performing smoke tests with Snapshot Standbys on a regular basis to verify release changes functionality before converting back to Physical Standbys.

.

.

+1-510-***-**** **.***********@*****.*** Oracle Database Administrator 19c OCP Certified

Providing performance tuning assistance to clients using various tools and methodologies such as Explain Plan, Baselines, SQL profiles, custom scripts, Wait Event Analysis, SQLT, TKPROF, AWR/ASH/ADDM Reports, Tuning advisor, SQL TRACE, SPA Database parameters & OS parameters. Conducting in-depth analysis to identify root causes of performance issues.

Conducting switchover and failover procedures to support scheduled maintenance or address unexpected outages.

Identifying and resolving problems associated with Data Guard replication, network connectivity, and configuration inconsistencies.

Implemented automated scripts for daily database refresh using PDB clone, Expdp/Impdp, and Rman as per the application team's request. This resulted in a 40%-time savings, enabling them to initiate testing promptly and achieve their business objectives.

In compliance with legal requirements and regulations, organize the transfer of data that is no longer needed, typically after a decade, to partitioned Archive tables. This action will reduce the workload on the primary table and enhance overall system performance.

Utilized OEM to monitor and resolve performance issues.

Ensuring compliance with industry standards, best practices, and relevant Federal regulations, including adhering to NIST standards and guidelines, is crucial for maintaining database security and privacy practices. This involves enforcing security protocols to safeguard data confidentiality, integrity, and availability, as well as overseeing user access and permissions.

Recording database configurations, procedures, entity relationship diagrams (ERD), and troubleshooting steps on Sharepoint or wiki pages establishes standardized procedures for the team and new employees, easing knowledge transfer and streamlining training. Delivering consistent reports on system performance and availability promotes transparency. Sr. Database Analyst (Feb 2011 to Mar 2018)

Role & Responsibilities:

As an L3 Operations DBA at a bank, I was responsible for supervising and managing database operations (Working on P1/P2/P3 Incidents) across various domains within the organization. This entailed carrying out intricate database tasks, monitoring db performance, resolving issues, safeguarding data integrity and security, executing database modifications, and cooperating with other teams to facilitate business activities.

Engaged with project teams, product owners and learned about the government regulations to follow while implementing the various projects to support BoA business models.

Possess practical skills in Data Guard/DR setups/DR Builds, Data Pump Refreshes, patching, upgrades, backup and recovery, Oracle RAC, Oracle ASM, grid, file system administration, tablespace administration, and user access management.

Performed different recoveries in the database.

Setting up of all Autosys jobs and done with entries in ONAMES and OID.

Experience on Oracle Server and Client Installations and patches.

Experience on DST Patches and JVM patches for Linux Servers.

Handling all kinds of tickets that are generated by monitoring tools.

Working with our Primary DBA (US & UK) and Onsite Team for Refreshes and other jobs.

Creating and adding tablespaces and adding space for tablespaces

Providing performance tuning assistance to clients using various tools and methodologies such as Explain Plan, Baselines, SQL profiles, custom scripts, Wait Event Analysis, SQLT, TKPROF, AWR/ASH/ADDM Reports, Tuning advisor, SQL TRACE, SPA Database parameters

& OS parameters. Conducting in-depth analysis to identify root causes of performance issues and improve performance for business end users.

Executing changes in Database Environments by following pre-defined change management policies and procedures as per bank standard over the weekend and Weekdays as required by application team.

To achieve efficient database design, implementation, and maintenance, close collaboration with the development team is essential for developing PL/SQL database packages, procedures, functions, triggers, indexes, and other components. By leveraging the expertise of both the DBA and development team, optimal database performance, data integrity, and application functionality can be attained.

Spend ample time in automating couple of day-to-day activities as per six sigma standards.

Configured and Maintained Oracle RMAN Backups. Done with catalog change of around 350 databases. Wrote backup script for all these 350 databases.

Revised and enhanced existing documentation by adding missing entity relationship diagrams (ERDs) and ensuring adherence to data standards for database configurations. Identified areas for improvement, compiled detailed reports, presented findings to stakeholders, documented their feedback and guidance for enhancements. Documented procedures and troubleshooting steps and generated regular reports on system performance and availability.

Offering support and training to fellow DBAs and technical teams on effective implementation practices, collaborating with team members, and staying updated on the newest features to remain informed about current trends, technologies, and best practices in Oracle database management. This ensures that database systems are in accordance with organizational objectives.

.

.

+1-510-***-**** **.***********@*****.*** Oracle Database Administrator 19c OCP Certified Analyst Apps Programming (Mar 2008 to Feb 2011)

Role & Responsibilities:

Installation and configuration of Oracle single instance/RAC 9i/10gR2 database.

Solving performance problems with the databases with respect to sql tuning, DB parameters tuning, OS level and network level Issues.

Managing On-Call 16x7 production Support for global databases.

Restoring databases using RMAN.

Upgrading the databases to higher versions of Oracle.

Experience in various recovery scenarios using RMAN/Expdp

Configuring the DR databases and troubleshooting the various Issues related to the DR.

Recovery& performing switch-over.

Performing DR/ARC Drills once in every year as per App team request.

Installation and configuration of Oracle Application Servers.

Design & developed PL/SQL Stored Procedures & Database Triggers to Implement Business rules & Security.

Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performance.

Planning and implementing the Archival policies as per the requirements.

Deployment of applications and troubleshooting the issues related to application servers.

Contact this candidate