SUMMARY

• Senior IT Professional with over 15+ years of progressive experience in database administration, database architecture, software development, project management, client account management, operations management, programming, troubleshooting, technical support, application development, personnel supervision, client - relationship management, evaluating, directing, analyzing and problem solving.
• Very effective team player and leader with excellent communication skills.

TECHNICAL SKILLS

• Software Oracle 12c/11g/10g/9i
• Oracle Partitioning
• Oracle Replication
• RAC
• Dataguard
• Physical Standby
• Golden gate
• Exadata
• Oracle Parallel Server
• PL/SQL
• SqlNavigator
• Toad
• Sqlplus
• Sqlloader
• Sqlnet
• NET8
• Enterprise Manager
• Erwin
• ETL
• Informatica
• Business Objects
• Cognos
• Java
• Unix Shell Scripting python
• Java Server Pages
• Sybase
• Oracle Applications 11i/11.x/10.7
• Oracle Developer
• Oracle Designer
• Oracle 9iAS
• Web logic
• IBM Web sphere
• Blaze
• Tivoli
• Vignette
• Cold Fusion
• Crystal Reports
• MS Visio
• Rational Rose
• UML
• Erwin
• Visio
• MS-Project
• J2EE
• EJB
• JMS
• Java Servlets
• Java script
• HTML
• XML
• C/C++
• PRO*C++/Pro*C
• Perl
• Test Director
• Quick Test
• Load Runner
• UML
• Use Cases
• Veritas Cluster
• UNIX (Sun Solaris

PROFESSIONAL EXPERIENCE

Senior Principal Consultant - Lead Oracle DBA

Confidential

Responsibilities:

• Performing and managing multi node Oracle RAC (12c/11g/10g) installation, setup and administration in various unix flavors for multiple clients.
• Performing production installations, patching, upgrades, capacity planning, high availability planning, DR Strategy and Drills.
• Setup, Configuration and management of oracle dataguard and physical standby databases.
• Performance tuning with Oracle Diagnostics and Tuning packs, AWR, OEM Grid Control, Statspack and customized scripts.
• Handling and monitoring materialized view replication.
• Oracle 12c/11g/10g database performance tuning, SQL tuning, PL/SQL tuning on AIX, Solaris, Linux and Windows
• Running RDA and AWR to diagnose database performance issues
• Work with Oracle Support and Client DBAs to resolve issues.
• Maintaining SLA towards client’s response and actions/resolutions.
• RMAN Backup and Recovery scripts, configuration, monitoring and support using hot and rman jobs.
• Restore/Recover/Clone/Refresh databases in various scenarios. Perform test database refreshes from production backups.
• Handling golden gate replication - installation, setup, configuration and monitoring, Streams and Propagations.
• Involved in process improvement, automation, shell scripting and plsql programming for various client needs.
• Involved in ITIL Processes, Change Management, Incident Management, DR Tests
• Involved in promoting process improvement, quality enhancement and problem solving solutions
• Presenting Technical Information to senior management of clients, conducting internal training and mentor new dbas
• Work with and mentor L1/L2 Oracle dba teams for Oracle Grid control and initial level alerts

Lead Oracle DBA

Confidential

Responsibilities:

• Responsible as Lead global oracle database administrator and specialist at one of the largest financial investment firm in a consulting role.
• Responsible as Lead global oracle database administrator and specialist at one of the largest financial investment firm in a consulting role.
• Managing databases administration and architecture for fixed income, derivatives, equity, and backoffice line of business
• Performing production installations, patching, upgrades, capacity planning, Providing High Availability and Disaster Recovery Solutions and Drills, Oracle Data Guard Setup.
• Responsible for delivering solution to the global database management team to meet SLA, change management, risk management, incident management and outage management
• Responsible for installation, configuration of Oracle 11g/10g databases including 2 node RAC, dataguard and Grid Control.
• Responsible for database provisioning, configuring RMAN and OEM Grid Control.
• Responsible for performance tuning of applications, provide support to world wide databases and applications tuning following FTSS model using Oracle Diagnostics and Tuning Packs, Shell scripting
• Responsible for database patch management and upgrade management.
• Mentor team as Lead and prepare team members for onboarding process.
• Involved in planning, testing and implementation of business continuity plans (BCP) and DR solutions.
• Explore and suggest new technologies for process improvement and reducing overall cost.
• Managing release, incident and change management for software updates and patches.
• Manage migration of applications/databases to latest versions and technologies.
• Key driver for designing & architecting the databases and applications for handling multi terabytes of data.
• Overseeing projects from proof of concept to deployment and document maintenance procedures.
• Executing systems audits and ensuring compliance to organisational standards and best practices.
• Deploy security best practices for new application deployments.
• Solution provider after troubleshooting issues and performing root cause analysis
• Harmonizng with various teams across the globe and departments to accomplish milestones and successful completion of projects.
• Working closely with vendors, offsite delivery managers, co-ordinating SLA requirements, service delivery and provide development, uat and production support in an efficient way.
• Actively involved in the team building and people management practices.
• Involved in writing database store procedures, packages, functions, triggers and shell scripting.

Lead Oracle Database Administrator/ Database Architect

Confidential

Responsibilities:

• Database Architect and lead database administrator at one of the largest financial investment firm in a consulting role.
• Design and Architect the databases and applications for handling multi tera bytes of data. Spearhead the deployment of applications for fixed income. Also involved with derivatives, equity, and backoffice line of business.
• Secure and maintain application within the network and datacenter guidelines including large applications with multi-terabyte oracle databases including oracle 9i/10g and oracle RAC, and large Enterprise servers from SUN, HP and Egenera with Solaris, Linux and Windows Operating systems
• Administer large multi tera byte databases
• Installation and configuration multi node RAC servers on linux operating system enterprise wide.
• Provide High Availability, Disaster Recovery Solutions, Perform DR Drills from time to time for various applications and databases. Work and Coordinate with various teams across the globe.
• Setup and Configuration of Oracle Data Guard.
• Perform Oracle Performance Tuning using oracle diagnostics and tuning packs, AWR, sql profiles, gather stats, explain plans etc.
• Design and execute Business continuity plans and process with multi level backups and Disaster Recovery systems. Deploy Virtualization Infrastructure for redundancy and consolidation.
• Manage data protection utilizing data-reduplication and virtual tape technologies
• Management and monitoring using Oracle Grid Control and propriety process.
• Release Management for software updates and patches.
• Involved in writing and testing RMAN backup/ recovery scripts, perform test database refreshes from production backups.
• Oversee projects from proof of concept to deployment and document maintenance procedures
• Systems audits and compliance to organizational standards and best practices.
• Incorporate security best practices for new application deployments.
• Performance management and performance tuning with database servers for all applications.
• Troubleshoot database problems and perform root cause analysis.
• Provide assistance and support in daily systems and database management.
• Collaborate with various teams across the globe and departments to accomplish milestones and successful completion of projects.
• Work closely with vendors and co-ordinate SLA requirements and service delivery.
• Coordinated with offshore Managers for faster delivery and provided 24x7 development and support in an efficient way.