Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
SANKAR VEJALLA

SANKAR VEJALLA

Stockton,CA

Summary

A competent Techno Management professional with 18+ yrs. of experience in the following areas: ~ On Prem and Cloud Database Transformations ~ Cloud & Data Services ~ Cloud & Infra Transformation ~ IT Service Transition ~ IT Operations Streamlining ~ Key Account Management ~ Delivery Management ~ Risk Management Hands on Technical leader experienced in build and maintaining the Hybrid infrastructure for business. Solid experience in Technology Operations (especially on Data Services), Managing IT Projects across the Enterprise including System and Database Infrastructure, Delivery Management and Data Centre Migrations Proven Environment Management experience in provisioning and managing end to end environments in complex, multi stream application environments in line with defined KPI/SLAs. Effectively managed environment demand, capacity planning, allocation conflicts and scheduling especially on data services. Deft in heading Transition, Transformation & Migration activities for IT Infrastructure Projects and Off shoring of IT Services. Comprehensive experience in ITIL - Incident, Problem, Change, Configuration, Release and Deployment Management Dexterity in mitigating risks to enable a low risk transition / transformation using Best practices. Superior track record in Programs/Project Management activities encompassing planning, budgeting, resource handling, Risk Mitigation, and timely delivery of projects. Adept in analyzing IT needs, evaluating requirements, Management Centre modelling, business process management. An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management and significant experience working with steering committees and other project managers.

Overview

16
16
years of professional experience
1
1
Certification

Work History

TECHNOLOGY SERVICES LEAD

Bank Of America Merrill Lynch
01.2016 - 12.2023
  • Project activities like migration, upgrade, patches and refreshes
  • Implementation of RMAN Backups across all Oracle Databases
  • Shell scripting for database clone and other hardware monitoring
  • Implemented 9i features like UNDO tablespaces, Resumable space management, Segment space management, Redefining Tables, List Partitioning
  • Implemented scripts for Cold, Hot and RMAN Backups
  • Monitoring the System Global Area (SGA) components dynamically according to the requirement after observing different Hit Ratios, caching of small tables in the Database Buffer Cache, keeping the mostly used and huge packages in the Shared Pool
  • Creation of new database links and materialized views and setting up of database jobs for their refreshment.
  • Increased network reliability by upgrading hardware components and optimizing configurations as needed.
  • Conducted regular audits of IT systems, identifying areas for improvement and implementing necessary changes.
  • Streamlined software development processes by introducing agile methodologies, leading to faster project completion times.
  • Collaborated with business stakeholders to understand their needs and develop technology strategies that aligned with organizational goals.
  • Spearheaded the adoption of cloud-based technologies, enabling seamless collaboration among team members in various locations.
  • Self-motivated, with a strong sense of personal responsibility.
  • Strengthened communication skills through regular interactions with others.
  • Provided professional services and support in a dynamic work environment.
  • Identified issues, analyzed information and provided solutions to problems.
  • Exercised leadership capabilities by successfully motivating and inspiring others.
  • Participated in team projects, demonstrating an ability to work collaboratively and effectively.
  • Developed strong communication and organizational skills through working on group projects.
  • Proven ability to learn quickly and adapt to new situations.
  • Demonstrated respect, friendliness and willingness to help wherever needed.
  • Worked effectively in fast-paced environments.
  • Assisted with day-to-day operations, working efficiently and productively with all team members.
  • Proven ability to develop and implement creative solutions to complex problems.

Senior Database Analyst

Bank Of America Merrill Lynch
01.2011 - 12.2015
  • Managing Service and Infrastructure Delivery for Global Markets Domain - 30 member Oracle Team along with
  • Risk, Automation & Middleware Teams
  • Global Lead for Global Markets & Risk technology (GMRT) Projects such as ‘Monitoring Requirement
  • Set up and controlled user access levels across databases to protect important data.
  • Conducted thorough analysis of existing databases, identifying areas for improvement and recommending necessary changes.
  • Increased database reliability with the implementation of a robust disaster recovery plan, ensuring business continuity in the event of unforeseen events.
  • Conducted tests to identify issues and make necessary modifications.
  • Enhanced data security with regular audits, monitoring access controls, and updating policies.
  • Streamlined data migration processes, ensuring accurate and timely transfer of information between systems.
  • Implemented robust backup strategies, minimizing risk of data loss in case of system failure or other emergencies.
  • Improved database efficiency by implementing performance tuning and optimization techniques.
  • Ensured seamless integration between multiple databases by designing and implementing effective data integration solutions.
  • Optimized query performance through proper indexing strategies resulting in faster response times from applications.
  • Maintained up-to-date documentation on database structures, procedures, and user guides for efficient knowledge sharing among team members.
  • Collaborated with cross-functional teams to develop comprehensive data solutions addressing business needs.
  • Troubleshot complex database issues promptly, reducing downtime and ensuring uninterrupted access to vital information resources.
  • Reduced system downtime by proactively monitoring database health and performance, identifying potential bottlenecks, and initiating corrective actions.
  • Self-motivated, with a strong sense of personal responsibility.
  • Demonstrated strong organizational and time management skills while managing multiple projects.
  • Demonstrated leadership skills in managing projects from concept to completion.
  • Worked flexible hours across night, weekend, and holiday shifts.
  • Gained strong leadership skills by managing projects from start to finish.
  • Document’ to Identify and address Monitoring Gaps & BBDA Inputs Projects
  • Led Adoption and execution of New Automation Tool Implementation Project and increased the effectiveness of the same to 60% in Oracle Space
  • Worked on Automation Projects related to Business Transformation, improve Operational experience to meet organizational strategic goals and objectives through tactical execution of projects and programs
  • Setup and implement processes for Change Management to ensure better monitoring and controlling of different project attributes and implement corrective and preventive actions
  • Maintain Project level RAID (Risk, Issue, Actions and Dependency) Tracker for better traction of project variables and accountability
  • Work closely with all Key Stakeholders to have clear scope and business requirements defined to deliver agreed upon project outputs and benefits expected
  • Develop Key Stakeholder engagement with all IT and Business Partners identified to ensure required support and foster relationships to deliver projects within agreed upon cost, time and defined scope
  • Drive regular scheduled phase gate and health check reviews with key stakeholders and Steering group by producing project performance report as per Governance plan defined
  • Partnered with Country Head for GDCE and as part of 'Internal Mobility' Project – encapsulated new HR
  • Policies related to Talent Movement and Talent Retention
  • Certified in Global Markets Domain Knowledge as part of Banking Domain Programs
  • Completed BCP location setup for the team across India, USA & Mexico locations
  • Spend ample time in automating couple of DAY-TO-DAY activities as per six sigma standards
  • Developed a Career development program for fresh associates.

Sr. Software Engineer / (Database Administrator)

Bank Of America Merrill Lynch
03.2008 - 12.2010
  • Supported entire 1000+ databases across multiple regions
  • Implemented robust security measures to protect sensitive data and ensure system integrity.
  • Led software development initiative as subject matter expert and primary point-of-contact for project management staff.
  • Maintained comprehensive documentation of development work, facilitating knowledge sharing among team members.
  • Collaborated with clients to define solution requirements.
  • Coordinated with other engineers to evaluate and improve software and hardware interfaces.
  • Conducted regression testing and submitted observations to development team.
  • End to End Production support for all of the Merrill Lynch databases
  • Setup OID Multimaster replication process for Merrill Lynch
  • Working as a primary DBA for 4 production and 20 staging and development databases
  • Performance tuning using AWR reports and Production release
  • Migrations and up gradations, Infrastructure works like patrol, precise, backups, jobs etc
  • Resolved issues in RMAN backups as an onsite coordinator
  • Maintenance of Development/R&D/Production Databases
  • Configured and Maintained Oracle RMAN Backups
  • Done with catalog change of around 350 databases
  • Wrote backup script for all these 350 databases
  • Setting up of all Autosys jobs and done with entries in ONAMES and IOD
  • Done with Oracle Server and Client Installations and also patches
  • Done with 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,APAC ) and Onsite Team for Refreshes and Other jobs
  • Creating and adding tablespaces and adding space for tablespaces
  • User creations for Both UK and US Clients
  • Restoring archive files and running archive backups once the orarch mount point reaches its threshold
  • Refreshing databases in weekends
  • Configured and maintaining Data-Guard (Physical Standby database) for the production database and tested for Switchover, fail over, activating the standby to primary and zero data loss

Education

ITIL V3.0 Foundation Certification -

2015

ITIL Service Operation Certification -

2015

Master of Science - computer applications

ANDHRA UNIVERSITY, VISAKHAPATNAM
05.2006

AKRG COLLEGE ,

May 2006

  • MASTER OF COMPUTER APPLICATIONS (MCA)

Bachelor of Science - computer applications

ACHARYA NAGARJUNA UNIVERSITY, GUNTUR
04.2003

SVRM COLLEGE ,NAGARAM

APRIL 2003

BACHELOR OF COMPUTER APPLICATIONS

Skills

  • Cloud /Data
  • Services
  • AWS, GCP, AWS EMR, Big Data(EMR, Hive, Hue, Spark), Hadoop, Informatica, SAS, GCP
  • Bigquery, Redshift, Amazon Athena, Dynamo DB, Jupyter, RStudio, SageMaker, Quicksight
  • Qlik Sense & Qlik View, Qlik NPrinting, Workiva
  • Operating Systems Windows, Linux, AIX, Solaris, AWS Linux
  • DBMS / RDBMS MSSQL, Dynamo DB, PostgreSQL, DB2, Netezza, MySQL, Mongo, RDS instances in AWS
  • Oracle 8i, 9i, 10g, 11g, 12c on Linux, Unix, Solaris, AIX, Windows
  • Monitoring/GUI IPCenter, OEM, Precise, Patrol, foglight, RMAN, NetIQ, CommVault, CloudBerry, Mysql
  • Workbench, Robo3T ,Tivoli, Team Quest, Toad, Putty, Humming Bird, HPDMA,DLA,DRP
  • Mobaxterm, appdynamics, Opsramp, DataGrip
  • Markup / Scripting

Accomplishments

  • EDUCATIONAL QUALIFICATIONS
  • PROFESSIONAL CERTIFICATIONS (Internationally accepted)
  • EXECUTIVE DIGEST d
  • PRESANTH KRISHNAN
  • TECHNICAL DELIVERY AND OPERATIONS MANAGEMENT

Certification

  • [Area of certification], [Company Name] - [Timeframe]

Timeline

TECHNOLOGY SERVICES LEAD - Bank Of America Merrill Lynch
01.2016 - 12.2023
Senior Database Analyst - Bank Of America Merrill Lynch
01.2011 - 12.2015
Sr. Software Engineer / (Database Administrator) - Bank Of America Merrill Lynch
03.2008 - 12.2010
- ITIL V3.0 Foundation Certification,
- ITIL Service Operation Certification,
ANDHRA UNIVERSITY - Master of Science, computer applications
ACHARYA NAGARJUNA UNIVERSITY - Bachelor of Science, computer applications

Similar Profiles

CREATE PROFILE
SANKAR VEJALLA