Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sankar Vejalla

Stockton,CA

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. 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. I have continuously enhanced my skills in database administration, specialising 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.

Overview

16
16
years of professional experience
1
1
Certification

Work History

Senior Lead Software Engineer

Stockton Drug Inc
Galt, CA
02.2024 - Current
  • 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.

Sr. Database Services Lead

Bank of America
03.2018 - 12.2023
  • 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.

Sr. Database Administrator

Bank of America
02.2011 - 03.2018
  • 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.

Analyst Apps Programming

03.2008 - 02.2011
  • 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.

Education

Master’s in computer applications -

Andhra University

Bachelor’s in computer applications -

Acharya Nagarjuna University

Skills

  • Oracle Database Administration
  • Oracle versions 9i to 19c
  • Oracle installations, upgrades, migrations
  • SQL tuning
  • Security implementations, including data encryption
  • DBaaS technologies like Exadata
  • Snowflake
  • PostgreSQL
  • AWS services
  • Windows, Sun Solaris, HP-UX, RHEL operating systems
  • PL/SQL, UNIX Shell Scripting, Python (Knowledge)
  • IPCenter, OEM, Precise, Patrol, foglight, RMAN, NetIQ, CyberArk, Hashicorp password Vault, Tivoli, Team Quest, Tableau, Toad, Putty, HPDMA, DLA, Datical, Radical
  • TKPROF, EXPLAIN PLAN, AWR, Tuning Advisor
  • JIRA, ITSM, IPCenter, Nexus, BMC Remedy, Maximo, ServiceNow
  • Microservices Architecture
  • Performance Optimization
  • JIRA
  • Linux
  • Performance Tuning

Certification

  • Oracle Database Administration 19c OCP Certified

Timeline

Senior Lead Software Engineer

Stockton Drug Inc
02.2024 - Current

Sr. Database Services Lead

Bank of America
03.2018 - 12.2023

Sr. Database Administrator

Bank of America
02.2011 - 03.2018

Analyst Apps Programming

03.2008 - 02.2011

Master’s in computer applications -

Andhra University

Bachelor’s in computer applications -

Acharya Nagarjuna University
Sankar Vejalla