EXECUTIVE SUMMARY:

• Over 18 years of commendable experience working as Lead Oracle DBA with 9+ years as DBA Manager for major Fortune 500 Companies like Fox Entertainment Group(News Corp) MUFG - Union Bank(5th Largest bank in the world also known as Bank of Tokyo Mitsubishi UFJ),Regions Financial Corp(consulting), Gateway Inc,SAP AG,Tata Consultancy Services etc
• Managed a team of talented database engineers through effective time management, performance evaluation, and department goal setting.
• Routinely mentor the teams for motivation, engineering best practices, customer-oriented service, and focus on adequate and proactive technology support.
• Allocate database engineering resources to meet the needs of all application areas, support initiatives and conduct upgrades and database optimization while operating within established initiatives, service levels and operational budgets.
• Optimize database and platform computing costs through system design, deployment, and optimal use of vendors and contracts. Participate in department level technology roadmap development regarding data, information management, reporting and business intelligence.
• Closely collaborate with Application Development teams and participate in system development process in the capacity of a database architect. Review non-functional requirements, propose, design, and deliver supporting database systems.
• Collaborate and communicate with other IT functions for proactive support of initiative and maintenance needs. manage database related upgrades, and platform upgrade and technology standardization in support of applications, business intelligence, disaster recovery and database security.
• Exercise technical leadership to oversee the database architecture design and validation for multi-vendor database management systems across the enterprise.
• Initiate, promote, and exemplify technology management best practices in areas of capacity planning, database performance, license inventory, configuration, update, procurement, and vendor engagement. Identify and execute improvement opportunities - particularly in cross-team setting - aimed to improve system’s efficiency, reliability, scalability, and cost effectiveness.
• Assess and develop long-term strategic goals for enterprise database systems in conjunction with data owners, application owners, and other stakeholders.
• Design and implement database redundancy, high availability and fail over capabilities, data security policies, procedures for performance monitoring and fault monitoring, backup and restore requirements, disaster recovery and business continuity needs, and data archiving to ensure effective database performance, data protection and integrity of data assets.
• Conduct researches and make recommendations regarding database products, services, protocols, and standards in support of organization’s evolving data needs. Promote migration to database technology standards.
• Demonstrated leadership skills and the ability to achieve results, including significant experience with large scale projects and matrix management environments. Specific experience directing database and/or infrastructure teams. Proven ability to guide business and technical strategies through the development of a technology roadmap.
• Design and implement physical data models of complex multi-tier, service oriented applications.
• Perform database transaction and security audits. Establish appropriate end-user database access control levels. Develop routines for end users to facilitate best practices database use.
• Provide technical support by analyzing, diagnosing, isolating, and identifying database related problems. Create short term work-around to alleviate problem symptoms. Identify root causes, and create and/or execute long term remediation plans. Support corporate and IT level compliance related activities such as regulatory compliance, reporting, baseline, and verifications
• Design and development experience include building distributed computing applications and systems in a global network environment and understanding the performance implications of various system designs and architectures. Expert in Database administration and forming and managing team of Database Administrators(onshore as well as Offshore)
• Knowledge and working experience with SDLC and structured project management methodologies. worked with Offshore Database admin vendors like HCL Technologies, I Gate, TCS etc
• Singlehandedly Led and proposed critical performance enhancing tuning and new features which helped database performance significantly.
• In depth, up to date and broad knowledge of the Information Technology field including all major communications and computing technologies and trends, including significant domestic and international exposure.
• Excellent interpersonal, oral/presentation and written communications skills in both technical and non technical language.
• Proven leadership skills to motivate a staff to attainment of critical goals.
• Conceptual and analytical thinker, able to understand, analyze and synthesize complex business and technology issues and strategies.
• Team builder/player able to work effectively with others with a demonstrated cultural awareness for interactions in multicultural settings.
• Operated database services to meet and exceed SLA by planning, executing, tuning and managing proactively.
• Ability to bridge the business/technology communication gap with business leaders at all levels.
• Flexible and adaptable process oriented work style; strong demonstrated work ethic; personal time management skills.
• Knowledge of other databases like MySql,Sql Server 2012 and Greenplum for BIG data.worked with Greenplum vendor on POC.

TECHNICAL SKILLS:

RDBMS:  Oracle 12C/11g/10g/9i/8i/ with RAC, Data Guard, OLAP, OLTP,DW, SQL Server, Mysql,Greenplum for Big Data.

Web application:  Oracle iAS, Websphere, web logic, Tomcat, Jboss, portal

Hardware:  Solaris Sparc , IBM P7, Greenplum appliance

O/S:  Sun Solaris 5.10 , IBM AIX 7.1,6.1,5.x, Red Hat tikanga linux, HP UNIX 11.0, SCO UNIX , Windows 2003 to windows 10

Data warehouse :   Data guard, Partitions, Business objects ,Appfluent,Microstrategy,BO,Wherescape.

Database Tools :  OEM, RMAN, Data Guard, DATAPUMP, TOAD, ERWIN, ,Grid control,cloud control, DbArtisian, Embarcadero Studio , Spotlight,foglight,nagios.imperva,solarwinds,splunk,jira,otrs.

Backup Applications :  RMAN, Data guard, Netbackup, EMC, veritas , Tivoli Flashback , FRA ,Datapump.

PROFESSIONAL EXPERIENCE:

Vice President

• Manage the service providers/Offshore database vendors and set up standards of SLAs and base services costs
• Measured and reported to senior management all critical outstanding that were related to databases
• worked with auditors to ensure audits are in places and ensured SOX compliance is maintained.
• Deliver strong Performance trouble-shooting and tuning for critical production issues
• set up timelines/goals/regular meetings with DBA team and worked with app teams to ensure all projects are meeting the timelines
• worked with IT security teams for database security .
• Provided Executive Management team updates on a weekly and monthly basis regarding key milestones achieved by DBA Teams.
• Participated in Weekly CAB meetings for weekly database changes that happen in production databases.
• Conducted yearly Disaster Recovery Test scenarios for all productions databases.
• Lead a team of managed services sys admins for Greenplum database. Also did hands on Greenplum DBA work and tested database restores on DR server for Greenplum database.
• Supported wide variety of Oracle applications like Hyperion,OBIEE,Demanta and various finance modules.running on Oracle database.
• Set Up Active Dataguard in Oracle 11G /12C database.
• Reduced backup time of 8TB datamart from 2 days 15 hrs to 1 day.
• Worked with storage admins to reduce TDPO/sepaton VTL sizes.freed up 65 Terabytes of space.
• Incorporated ITIL Methodologies for Databases.
• Managed team of onshore/offshore DBA's and had regular conference calls/status updates on a daily basis.
• Implemented EMC datadomain which helped reduce RMAN backup time significantly and TDP licenses.
• implemented Netapp POD storage for new oracle databases on linux servers.
• Implemented Oracle 12C cloud control to monitor oracle databases.
• experience using modern software versioning and deployment automation tools, i.e., GitHub, Puppet, etc
• Set up Netapp Snap Manager for Oracle(SMO) to take backup/snapshots by creation repository/profiles for database and reducing backup times from days to minutes by taking advantage of Netapp Snapshot Technologies

Los Angeles-CA

Database Administrator Manager

• Lead a team of 6 Oracle DBA’s providing 24/7 on-call database operational support on rotation basis..
• Acted as a business Liason between Application team managers and DBA team.
• Brought new database solutions, established standards, set up expectations from the team
• Identify and resolve more than 95% issues proactively with Oracle database monitoring tools.
• ensured the database has sufficient capacity to meet peak season forecasts with 25% margin, while maintaining consistent response time. Effectively follow change management guidelines for all the changes made to the production and pre-production databases.
• Lead initiative to develop scripts and other programs for system monitoring and maintenance.
• Defined strategies for backups, migration of database changes, and longer term system growth.
• Lead projects and managed and mentored junior DBAs.
• Planning and implementation of database site scalability/capacity architecture to support 2x business growth.
• Lead Failure Point Analysis for database subsystem and implemented resulting projects.
• Make design recommendations to software projects and participate in technical reviews
• Working with the Data Director on standards, physical layout and design, capacity planning, participate in day to day trouble shooting, process improvement.
• Created, estimated and managed R&D projects staffed with other DBA' s that explore new technologies and concepts and generally improved productivity and process.
• Set a technical vision of improvement in all areas and selling that vision to
• Grow the technical abilities of the staff.worked with Offshore vendors/DBA' s and provided complete knowledge transfer to them.
• Reorganized databases and sized database objects to meet standards and improved performance by 30%
• Set up physical standby database from scratch and created new disaster recovery environment. this was the first standby database in Fox.
• Migrated Oracle databases from Solaris servers to Linux servers which involved converting oracle databases from Big Endian format to little Endian format saving tens of thousands of dollars in licensing, hardware, support costs.

Irvine-CA

Lead Oracle DBA

• Monitor and optimize database performance. Resolve all performance issues caused by historical Oracle architecture and application design.
• Upgrade and migrate Oracle databases from various versions to 9i
• Perform complete and incomplete database recovery. Plan and perform Disaster/Recovery testing.
• Establish, review and maintain enterprise database standard and best practices covering backup/recovery procedure, monitoring scheme, space management, and database cloning method
• Apply Critical Patch Updates using opatch on a regular basis.
• Maintaining Production Oracle Databases and providing support to end Users on a 24*7 Basis. (Pager)
• Ongoing performance tuning work for the database using utilities like statspack, TKPROF, Autotrace, TOP SQL and Explain Plans and AWR in oracle 10G.
• Create new test and development databases for the people soft team by cloning the production database on a regular basis
• Refresh databases on a regular basis from cold backup as well as hot database backups (RMAN Backup) on a weekly basis.
• Monitor production databases by setting alerts for listener, tablespace threshold values etc through Oracle Enterprise Manager (OEM) and Data Control.

Memphis-TN 

Lead Oracle DBA

• Responsible for relational database design, capacity planning creating and administering databases in Oracle 10G, 9i
• Installed Oracle Security Alert Patches on Oracle databases supporting people soft HRMS, Mortgage groups etc.
• Migrated databases from Oracle 8i to Oracle 9i using database upgrade assistant as well as export import.
• Maintaining Production Oracle Databases of the Bank and providing support to end Users on a 24*7 Basis. (Pager)
• Ongoing performance tuning work for the database using utilities like statspack, TKPROF, Auto trace,TOP SQL and Explain Plans
• Refresh databases on a regular basis from cold backup as well as hot database backups (RMAN Backup) on a weekly basis.
• Creating shell scripts and setting up cron jobs for regular cold back up of test/development database, and hot backup of production database using RMAN.
• Monitoring production databases by setting alerts for listener, table space threshold values etc through Oracle Enterprise Manager (OEM).

Oracle DBA Manager

• Create and configure Oracle database instances in support of development and Production activities and initiatives.
• Planned database capacity, memory structure and physical layout includes rollback segment, temporary segment, control file, archive and redo log file.
• Work as a Team leader managing a group of application developers.
• Resolve error messages (except coding correction by using SAP Notes or Customer messages, debugging tracing, verifying complex customizing/hardware parameters.
• Create Database Links to access data from various databases.
• Perform performance optimization using Explain Plan, SQL Trace, and Optimizer Hint etc.
• Involve in writing various UNIX Shell scripts for monitoring related jobs scheduled in cron.

Confidential

Oracle Database Administrator

• Implementation of Trade Finance module of Eximbills at several branches of SBI.
• Installation and Creation of Application software and creating Oracle database at branch level.
• Involved in Security/User Management.
• Data migration from Fox Pro to Oracle 8i: Preparing staging area for data migration. Preparing extraction templates. Running validations on extract files prior to upload and generating exception reports till no exception is observed.
• Involved in Security/User Management, Backup/Recovery in a 24/7 Production support
• Used Tkprof, Explain Plan, SQL trace utilities for optimizing SQL queries.

Confidential

Database Administration and Tuning

Responsibilities:

• Installation of Oracle Server (Enterprise as well as workgroup) and other Oracle Products on different flavors of UNIX.
• Creation of test and physical databases.
• Creating and maintaining table spaces, rollback, segments, users and user privileges.
• Monitoring segments and table spaces about to exceed maximum space.
• Analyzing tables and indices to generate statistics used for tuning.
• Estimation of database size and tuning memory areas
• Import and export backups.
• Recovery of database from loss of control file, loss of data file, oracle internal process terminations
• Personal Details: American Citizen ready to relocate for the right job.