SUMMARY:

• Senior Remote Database Administrator
• 20 years: Oracle Certified Professional (11g, 10g, 9i, 8i) Database Administrator. Working on 12c Cert.
• 10 years: SQL Server DBA, all versions.
• 5 years: MySQL DBA (v4x, 5x)
• 5 years: Sybase 11x DBA.
• 20 years: Experience with many operational environments and software applications including all Windows OS’s, Linux, IBM AIX, HP - UX UNIX servers.
• Summary of related Oracle / SQL Server, MySQL and Sybase experience:

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential

Responsibilities:

• High Availability Monitoring: Clustering, Database Mirroring, Log Shipping and Backups.
• Database Monitoring: Database Status, Blocking, Deadlocks, Query Performance, Indexing Needs, Database Corruption and Replication.
• Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting. Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database.
• Resolve database performance issues, database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Databases.
• ADHOC Crystal report writing.
• Export and import of data.
• Performed complex data migrations from legacy Sybase, DB2, SQL Server databases to Oracle environments on AIX and HPUX platforms for long-term longitudinal data storage.
• Design and implement DB security, user management.
• High availability, 24/7, clusters, replication, standby database, RMAN.
• Plan and Design Backup/Recovery solutions using shell scripts and RMAN.
• Oracle quarterly patching and upgrades.
• New Oracle installs and database cloning.

Senior SQL Server DBA

Confidential

Responsibilities:

• SQL Server Instance Monitoring: SQL Server Connectivity, SQL Server Agent Service, Analysis Services Service, Reporting Services Service, SSIS Service, Service Broker Service, SQL Server Agent Jobs, SQL Server Alerts, SQL Server Log, SQL Server Agent, Policy Violations and SQL Audit Events .
• Database Monitoring: Database Status, MDF and LDF Sizes, tempdb Size and Performance, Blocking, Deadlocks, Query Performance, Indexing Needs, Database Corruption and Replication.
• Implementing and Maintaining Log Shipping | Database| Clustering | Mirroring | Always On HADR.
• ADHOC Crystal report writing.
• Export and import of data.
• Design and implement DB security, user management.
• New SQL Server installs, upgrades and quarterly patching.
• Responsible routine DBA jobs like Backups and Restores.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plans.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Performance Tuning via Activity Monitor, SQL trace procedures, DBCC functions…
• Basic SQL Development, T-SQL adhoc queries, creation of tables, indexes and views.

Senior MySQL DBA

Confidential

Responsibilities:

• Professional and highly motivated, having over 5+ years of DBA work experience in the software industry with MySQL (4.x, 5,x).
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql Server installation, upgrade, migration.
• Successfully managed high availability of production systems for many business sectors as MySql DBA.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases.
• Experienced in designing, modelling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, database optimization with the help of explain plan.

Senior Sybase DBA

Confidential

Responsibilities:

• Support a production system setup comprising of Sybase v12 and 15.0.3 ASE servers, Replication Servers 15.7.
• Monitor crontab jobs daily and rectify issues if any.
• Schedule and monitor db maintenance activities such as reindexing, reorg, dbcc during maintenance slots.
• Automated the dump and load of databases using korn shell scripting.
• Open Change Request tickets in the CA ticketing system, get approvals, present the change on Change Board Meetings and implement the changes in the production and DR servers during maintenance slots.
• On call providing 24/7 Sybase and Replication Server DBA support for all incident calls. This involved working with Applications Support team and Operations Team to resolve the incident Request Tickets.
• Create ASE thresholds and threshold procs for space management.
• Expertise in Sybase database setup, space management, backup and recovery