SUMMARY

• Over 21 years DBA expertise with Oracle RDBMS platform
• Over 18 years of DBA expertise with SQL Server RDBMS platform
• Over 13 years of DBA expertise with MySQL/Sybase RDBMS platform
• Sr. Level DBA with hands expertise with database performance analysis, design, performance tuning, upgrades, replication, High Availability implementation, Backup & Recovery implementation and database capacity planning expertise.
• Proficient in Windows 2008 - 2012.
• Sun Solaris, Red Hat Linux, HP-UX, AIX, T-SQL, SQL*Plus, PL/SQL, C/Unix, C++, C#,VB .NET, VMARE, UNIX Shell Programming, Oracle, SQL Server, MySQL, Sybase, Sybase IQ, ASA, Unidata, Oracle 8/8i/9i/10g/11g, Oracle Enterprise Manager (OEM)/Oracle Grid Control, Oracle E-Business Suite, Oracle Apps, Oracle Access Management.
• Oracle Hyperion, Big Data, RMAN, Oracle RAC, Data Guard, Oracle Steams, Export/Import, Data pump, SQL SQL Server versions7/2000/2005/2008/2012/2014 SQL Server Cluster, Business Analysis, Oracle Business
• Objects, SQL Server Business Objects, SSIS, SSRS, SSAS, Java, and HTML. MCITP SQL Server DBA Certified, Microsoft Stack development tools, Crystal reports, MS Dexterity IDE, MS Dynamics (GP AX CRM ERP), MongoDB and PostgreSQL.

PROFESSIONAL EXPERIENCE

Confidential Atlanta, GA

DBA Architect Consultant

Responsibilities:

• Serve as DBA Architect Team Lead.
• Provided data modeling, database schema design, Big Data visualization packages and database management policy and procedures documentation. Implement Oracle Apps, PeopleSoft, Maximo, MS Dynamics (Great Plains,AX, CRM, ERP), Oracle E-Business, Business Objects etc.) And SQL Server BI Components and Business Objects for Data warehouse environment. Implemented MySQL to SQL Server migration process, SQL Server to MySQL migration process, and SQL Server to Oracle migration process and Oracle to SQL Server Migration process. Implementation of Sybase, Sybase IQ, Sybase ASE, ASA and MySQL Cluster. Used DB Artisan and Toad as third party DBA admin tools.
• Implemented Database Audit and Security Policy & Procedures documentation.
• RDBMS DBA support for Oracle databases, SQL Server databases, OLAP databases, Oracle Financials, PeopleSoft, Hyperion, developed Hyperion reports, CRM and internal applications. Installed, configured and administered Prod, QA and Test Oracle RAC environment for high availability. Vmware configuration. Configured SQL Server SSIS, SSRS and SSAS.
• Installed, configured and administered Production, QA and Test SQL Server Cluster 2012, AlwaysOn, SQL database mirroring, SQL Server replication and Geo Clustering environment for high availability implementations, MongoDB and PostgreSQL.
• Set up stand by servers for Reporting/data warehousing and Disaster recovery plan for Oracle & SQL Server MySQL RDBMS environment.
• Worked on Oracle, SQL Server, MySQL, DB configuration and Performance Tuning.
• Implemented Oracle Data Guard, Oracle streams, Golden Gate Replication, backup and recovery plan policies and procedures.
• Installed and setup replicated instance of Oracle database for supporting Internet application and reporting.
• Designed and developed data model for application enhancements.
• Re-organized database and re-architected application server to resolve performance issues. Monitored database and application, tuned SQL queries, indexes, Oracle initialization parameters, and clustered application servers.
• Supported application administrators, application developers with application and system design/architect, business analyst and configure PHP applications and db connections.
• Designed, developed reports using SSRS, and implemented Data Warehouse / DSS systems using Oracle Gather and analyze production database performance to ensure proficient performance on all production databases. Databases supported on Windows, Unix and Linux. Unix scripting and crontab scheduling.

Confidential, Atlanta, GA

Sr. DBA Architect Consultant

Responsibilities:

• Serve as DBA Architect Team Lead.
• Provided data modeling, database schema design, and database management policy and procedures documentation. Implemented enterprise apps such as PeopleSoft, Oracle Financials, Maximo and Great Plains.
• Implemented Database Audit and Security Policy & Procedures documentation.
• Installed, configured and administered Prod, QA and Test Oracle RAC environment for high availability.
• Installed, configured and administered Production, QA and Test SQL Server Cluster environment for high availability.
• Set up standby Oracle, SQL Server, Sybase, ASA and MySQL database servers for Disaster recovery.
• Created and modified physical database objects.
• Upgraded Oracle instance from Oracle 8i to Oracle 9i.
• Upgraded SQL Server instance from SQL Server 2000 to SQL Server 2005.
• Backup and recovery of databases and documented the procedure.
• Create test databases from the production environment.
• Create and maintain users, privileges, views, tables, synonyms, sequences and indexes in Oracle 8i, 9i, 10g SQL Server 2000 and SQL Server 2005 as per the need.
• Managed stand-alone report servers and their jobs.
• Provided 24x7 on-call support for OLTP database and disaster recovery support.

Confidential, GA

Sr. DBA

Responsibilities:

• Served as Team Lead.
• Implemented Database Management Policy & Procedures documentation.
• Managed Oracle, SQL Server, and Sybase databases for both Production and Development environments.
• Served as DBA Manager over 5 DBA’s.
• Developed strategic database architecture plans and data modeling for Oracle, SQL Server and Sybase databases.
• Developed and implemented database triggers, T-SQL and stored procedures within Oracle,
• SQL Server and Sybase.
• Managed and maintained Oracle instances and SQL Server 6.5, 7.0 & 2000 Databases both production and development environments.