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, AT&T SVR4, HP Unix, IBM AIX, SCO, UNIXWARE, DEC), Red Hat Linux, MS-Windows, Golden Gate, Big data, HDFS, MapReduce, Hive, Pig, Hbase,Sqoop, Scala, MongoDB, NoSQL, Cassandra, AWS

Hardware: Linux Servers, Sun 10000, Sun 6800/4500, Sun Solaris, HP 9000 series, AT&T/NCR 3000 Series, U6000/65, IBM RS6000, Compaq Servers, Dell Servers, Window servers and PC client workstations.

KEY COMPENTECIES:

• Research, identified and resolved the production oracle database servers crashes happening firmwide during regular business hours. This effort led to the stabilization of the oracle databases servers which resulted in savings in millions of dollars of business loss.
• Lead the enterprise wide migration of Oracle 10.2.0.1 using OCFS on 32bit Redhat to Oracle 10.2.0.3 using CRS on 64bit SLES9. This successful complex migration process eradicated the weekly reboots of production database servers firm wide and saved millions of dollars to the firm in lost business activity and labor intensive work.
• Successfully achieved highly tuned applications database design and higher security for the database and improved regulatory compliance by removing spy violations and designing, testing and deploying the secure and audit enabled databases and applications.
• Reduced the clients database backup time by more than 50% and also reduced space requirements for backup and recovering by 50% resulting in huge savings in cost and time saving and avoidance of buying additional hardware and software licenses and testing of applications thereafter.
• Successfully worked with Product Team, development teams and QA teams in USA, UK, Singapore and India and mentored them in database design, development and admnistration process.
• Efficiently setup the new offshore vendor in India. Directed and trained vendors IT development teams, developed the product rapidly at reduced cost and gained multiple additional customers for clients.
• Efficiently migrated databases of size tens of terabytes from Sun Solaris to Linux platform with minimal down time. Also migrated oracle databases from 8k to 16k with zero downtime.
• Effectively recovered databases of clients multiple times resulting in huge cost and time savings.
• Effectively setup highly available database systems and DR sites.
• Effectively and efficiently worked with top level management like CEO/CTO/COO to support them in long-term IT vision for the company, which resulted in competitive edge to develop and market better products faster.
• Effectively worked closely with vendors, offsite delivery managers, co-ordinated SLA requirements and resulted in effective service delivery for development, uat and production support of applications and databases.

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.
• 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.
• In corporate 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.

Lead Database Architect

Confidential

Responsibilities:

• Managed database architecture, database design, data modeling, development and deployment of the Pricefeed and Reference data application.
• Project management, requirement gathering, planning, analysis and design of Use Cases and creation of Data model for Pricefeed application software. Managed onsite and offsite development teams.

Sr. Director of Technology

Confidential

Responsibilities:

• Responsible for managing the software development team, database team, architecture, unix, windows and infrastructure of a startup company, which developed innovative Streaming media products like Campaign Manager for online advertisement, Ad Insertion, Content Management and Pay Per View.
• Responsible for evaluating and purchasing of the hardware, software and involved in configuring servers, routers, switches, firewall, load balancers, web server farm. Built datacenter right from scratch.