SUMMARY:

• Twenty plus years of overall experience in the administration, management, analysis, design, development, testing and implementation of large scale client/server applications, including oracle RAC, SQL Server Cluster, and PostgreSQL.
• Five plus years of DBA Manager experience.
• Five plus years of experience in establishing audit procedures and compliance standards.
• Fifteen years of hand on experience in SQL Server administration.
• Fifteen years of hands on experience in Oracle database administration.
• Strong working knowledge of Oracle 11.x, SQL/PL SQL, SQL Server 2008/2016 and extensive use of Oracle tools.
• Excellent communicator with the dedication to see any project through to completion.

TECHNICAL SKILLS:

O/S: Unix, Linux, AIX, Windows - 2003/08/12.

SOFTWARE: SQL Server, Oracle 11.x / 12.x, RMAN, PostgreSQL 10, Delphix, Foglight, DBArtisian.

HARDWARE: HP L class, HP N class, HP 9000 (HP-UX), HCL HP- Server Pentium (SCO-UNIX/Windows-NT), Intel Linux (Red Hat 7.2) servers, Sun Solaris, Wipro Acer (SCO-UNIX), Digital (Windows-NT 4.0), Compaq Server (SCO-UNIX).

EXPERIENCE:

Confidential, New Jersey

Senior Database Engineer

Responsibilities:

• Owning, tracking and resolving database related incidents and requests.
• Support for all database production issues, and the deployment of database changes, enhancements, and corrective measures for Production and Disaster Recovery environments.
• Install, configure, and upgrade Oracle/MSSQL/PostgreSQL server software and related products.
• Migrate Oracle databases from version 11.2.0.3 to 12.2.0.
• Migrate SQL Server 2008 to SQL 2016 and Oracle HP-UX to Oracle Red Hat Linux.
• PostgreSQL Administration.
• Monitoring and troubleshooting Database Backups (Symantec NetBackup).
• Oracle RMAN backups & restores.
• Provide 24 X 7 support.
• Perform database tuning and performance monitoring.
• Perform application/SQL tuning and performance monitoring.
• Unix / Linux Shell scripting.

Environment: Oracle 12.2.0, RMAN, SQL Server / 2016, PostgreSQL 10, HP Unix, Linux, Windows, OEM, Oracle WebLogic 12c, NetBackup, Veam, Tidal, EMC SRDF (Symmetrix Remote Data Facility), Vmware.

Confidential, New Jersey

DBA Lead.

Responsibilities:

• Manage a team of database administrators, including remotely based (Canada) administrators.
• Manage the on call DBA calendar, assess annual performance, set up SMART goals for new calendar year.
• Implement auditing procedures and compliance guidelines for the DBA team. The organization has to be compliant with several Federal rules and regulations and hence my responsibilities include ensuring confidentiality, integrity and availability of our databases.
• Capacity plan tablespaces, datafiles, tables, indexes according to application requirements, and size instances.
• Design RAC environments. A standalone windows Oracle 9i database had to be migrated to Linux RAC Oracle 10G environments. I was also responsible for installing Oracle RAC softwares. Oracle RAC’s ASM features were used to develop databases in development environment. Production and QA environment do not use ASM features.
• Manage migration project to upgrade Oracle 10.X databases to Oracle 11G Release 2 databases. Responsibilities also include designing new servers for the new data center and disaster recovery location.
• Manage migration project to upgrade SQL Server 2005 to SQL Server 2012. Responsibilities also include designing new servers for the new data center and disaster recovery location.
• Managed migration of Oracle/SQL Server databases, Oracle web servers from existing hosting facility in Ohio to a new hosting facility in Denver.
• Managed migration of data from Oracle 9.X to Oracle 10.X and 10.X to 11.X. Company policy is to keep using latest Oracle versions and hence the migration.
• Installed SQL Servers on stand-alone, multi instance and virtual environments using MS Virtual PC and VMWare.
• Manage migration project to upgrade SQL Server 2005 to SQL Server 2012.
• Set up SQL Server Replication and SQL Server DR (database mirroring).
• Designed backup/recovery/failover plans for multiple hosting facilities. Cold backups were replaced with hot backups using new company policy to use RMAN for backup and recovery. Designed and developed scripts to clone databases using hot backups.
• Designed and implement Disaster Recovery (DR) solutions. Created DR databases using Oracle’s data guard features. These databases are in standby mode and can be activated immediately if the production databases are unavailable due to a disaster.
• Co-ordinate testing with different testing groups
• Overlook the development of various shell scripts. Besides using third party tools to administer and monitor, I strongly believe in scheduling OS scripts on the servers to alert DBAs and developers about different events occurring both in the databases as well as on the servers.
• Set up standards. The existing database architecture was designed and updated by different employees. Since, everything was being designed from scratch; I decided to develop standards for different processes.

Environment: SQL Server 2000/05/08/12 , Oracle 11/10/9, RAC, RMAN, OAS, Oracle Web Servers, Sun Solaris Unix, Linux, Windows, Vmware, OEM, DB Artisan.

Confidential, New York

DBA Manager.

Responsibilities:

• Manage a team of database administrators.
• Capacity plan tablespaces, datafiles, tables, indexes according to application requirements, and size production instances
• Provide weekly status updates.
• Hands on DBA for Oracle’s and Sql Server’s Production, QA and Dev environments. Lead DBA for 50+ Oracle databases and 60+ SQL Server databases. Most of the Oracle databases were on Linux OS. These were migrated from HPUX and Solaris systems.
• Provide 24X7 production support for mission-critical database related trouble. I would login remotely (from home) to troubleshoot and resolve problems.
• Administer RAC databases. The RAC setup consisted of 2 nodes and 1 instance on each node. Load balancing and failover was achieved by this setup.
• Administer Standby databases for Disaster Recovery using Oracle’s Data Guard features. Two of the mission critical applications had standby databases. Both the primary and standby databases were kept in sync with automatic log shipping between the two sites.
• Design the ETL architecture for data warehousing applications. There existed a couple of data warehouses. These were loaded using ETL scripts which run daily. The scripts were developed by me.
• Set up the Production and QA environments.
• Develop shell scripts to automate processes. Company policy was to rely more on shell scripts than on any monitoring tools. I was involved in developing most of the monitoring scripts.
• Install Oracle Enterprise Editions. I was responsible for installing different versions of Oracle on different Operating Systems.
• Set up scripts to copy production databases into QA, logical backup, etc. Some of the QA databases were automatically refreshed with the earlier night’s production data. Besides cold and hot backups, I was also responsible for doing logical backups.
• Responsible for using RMAN to make cold and hot backups.
• Manage day to day DBA activities. These included monitoring, trouble shooting, performance tuning.
• Assist in setting up data level security using OLS.
• Administered Legacy Oracle databases on AIX.

Environment: Oracle 11.x, Oracle 10.x, Oracle 9.x, Oracle 8.x, RAC, RMAN, SQL Server 2005, SQL Server 2008, Unix HPUX X1 (64 bit), Sun Solaris, Linux, Windows, OEM, DB Artisan.

Confidential, New Jersey

Primary DBA

Responsibilities:

• Capacity plan tablespaces, datafiles, tables, indexes according to DW requirements, and size production instance
• Create databases in development, testing and Production environments.
• Define standards and naming conventions for back-end objects and databases.
• Apply patches, configure, and tune Oracle servers for performance
• Write scripts and monitor logical backups.
• Restore database objects from the compressed export dump.
• Manage schema objects like Tables, Views, Procedures, Triggers, Packages, Functions.
• Manage and maintain database consistency and referential integrity.
• Troubleshoot user related and database related issues
• Migrate data between databases .
• Define and write procedures to load data from ASCII files to Oracle database
• Tune database for optimal performance.
• Act as a coordinator between the users / developers and the corporate Unix group.

Environment: Oracle 8i, Unix HPUX X1 (64 bit), OEM.

Confidential, New Jersey

DBA

Responsibilities:

• Install Oracle 8i on Unix boxes.
• Setup development, regression, and production environments
• Support 8 servers in development, QA and Production databases .
• Use unix raw devices for Oracle space management.
• Each database was approximately at-least 20 gigabytes.
• Take nightly exports and weekly backups using cron jobs.
• Manage schema objects like Tables, Views, Procedures, Triggers, Packages, Functions.
• Create users and set up different levels of security using roles.
• Help the developers in tuning queries.
• Move data between databases to help in testing and trouble shooting production problems.
• Make modifications to the database structure as required by the application developers and changes in design.
• Onsite, and extended hours’ support for development
• Write scripts to automate the synchronization process between local and remote databases
• Monitor performance, storage, backup logs, database logs, tables, extents, indexes, and all other back-end objects in production.
• Manage overall security for all the databases.
• 1st point of contact for any Oracle related issues.

Environment: Oracle 8i, Unix HPUX X1 (64 bit), OEM, DBArtisian, Toad.

Confidential, New Jersey

DBA

Responsibilities:

• Data model the different FRE applications using Designer 2000.
• Develop and maintain a Web based application for publishing the data models using Oracle Web Server and Microsoft Front Page.
• Support development and QA databases with 20+ Developers and around 8-10 servers.
• Manage schema objects like Tables, Views, Procedures, Triggers, Packages, Functions.
• Create users and set up different levels of security using roles.
• Help the developers in tuning queries.
• Move data between databases to help in testing and trouble shooting production problems.
• Designed the table structure for the database application.
• Estimated storage requirements for the tables and indexes based on data volume.
• Made modifications to the database structure as required by the application developers and changes in design.

Environment: Oracle 7.x and 8.x, Designer 2000, ERWin, Oracle Web Server, OEM, Microsoft Front Page.