SUMMARY:

• DBA Professional over 15 years experience in Microsoft SQL, Sybase and Oracle databases., with over 12 years experience in Oracle E - business Suite applications, 1 year experience in Mongo, MySQL databases.
• Programming languages including Shell, Powershell, Perl, Sybperl, T-SQL and PLSQL.
• Familiar with Unix, Linux, Windows platforms and VM, SAN storage, SRDF, SRM, Data Domain and Netbackup.
• Strong analytic and problem solving skills. Track record of meeting critical deadlines.

TECHNICAL SKILLS:

Database: Microsoft SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014 and 2016. Oracle 8i, 9i, 10g, 11g and 12c. Sybase and Replication 11.9,12.0,12.5, 15.0 and 15.5. Mongo Server 3.2.8. MySQL RedHat 5.6, 5.7

Oracle EBS: Version 11.5.10.1, 11.5.10.2 and 12.1.3

SQL Server Utilities: DB mirroring, log shipping, replication, Failover clusters, AlwaysOn, SSIS, SSAS and SSRS

Sybase Utilities: Sybase Enterprise Connect to Oracle, DMA, optdiag, Sybase replication.

Oracle Utilities: RMAN, Datapump, ASM, Dataguard, Statspack, AWR, Oracle Sybase Gateway. Oracle RAC.

Paltform: Unix, Linux, Windows and Virtual platforms.

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Senior DBA Consultant

• Set up Microsoft SQL server inventory by using Microsoft MAP Toolkits.
• Created and implemented multiple Powershell and T-SQL scripts to monitor disk space usage, missing backups, AlwaysON Avaiability Group failover and CPU utilization.
• Created and implemented database backup scripts for databases on AlwaysON cluster.
• Troubleshot and fixed an AlwayON Avaiability Group failover issue.
• Troubleshot and fixed a SQL Server hanging problem.
• Helped our user to resolve a stored procedure performance issue by analyzing the procedure and its execution plan and created a better covering index.
• Created and configured SQL server mail profiles to let user send out e-mails and text messages in SQL servers.
• Upgraded SSAS from version 2012 to version 2016, and migraded its Windows host.
• Installed RedHat MySQL community version 5.6. Built multiple MySQL instances on one Linux host. Set up their backups.
• Troubleshot and fixed a SSIS package for MS SQL server audit reporting in the SSIS Catalog.

Confidential, Jersey City, NJ

Senior DBA Consultant

• Installed and configured multiple MS SQL server 2008R2, 2012, 2014 and 2016. Applied Multiple Service Packs and Cumulative
• Updates for each version.
• Installed and configured MS SQL server 2012, 2014 on Wnidows Failover Clusters.
• Set up multiple SQL server DR enviroments by using database Mirroring, Log shipping, SRM and SRDF.
• Upgraded multiple SQL servers from SQL server 2008 to SQL server 2008R2, 2012 and 2014 with the latest Service Pack.
• Set up multiple SQL Agent jobs for Backups, Update Statistcs and rebuid indexes. Set up databases auto refresh jobs.
• Troubleshot database performance issues in SQL server by using dynamic management views and functions.
• Helped our user to resolve multiple Query performance problems in both SQL server and Sybase databases.
• Supported SAP Sybase ASE 15.5, 15.7 and 16.0 and replication server 15.5 and 15.7.
• Troubleshot and resolved Sybase replication multiple replication threads down issues and resumed connections.
• Using MDA tables to troubleshot Sybase performance issues.
• Take turns to do 24x7 production on call support. Supported MS SQL server and Sybase database and Sybase Replications.
• Set up SQL server linked servers to Sybase and Oracle databases.
• Set up SQL server database TDE encryption. Copied its MasterKey and certificate to different SQL servers.
• Set up SQL server SSL connection.
• Created and configured SQL server mail profile to let user send out e-mails in SQL server.
• Used SQL Profiler and PerfMon to monitor user applications against SQL server performance.
• Troubleshot and resolved SQL server issues related to Service Broker conversation endpoint leak.
• Installed and Configured MongoDB. Created a MongoDB with multiple replicas, and a MongoDB with 1 replica and 1 arbitor.
• Set up MongoDB monitoring and backup jobs.

Confidential, Newtown, PA

SQL Sever DBA

• Designed database tables, primary keys, foreign keys, indexes and procedures for NetSuite schema by working closely with our business users.
• Migrated General Ledger from JD Edward to NetSuite successfully.
• Created multiple procedures to produce reports in CSV files according to user’s requirements.
• Troubleshot application performance problems, analyzed query execution plans and resolved the issues.
• Export and Import SSIS packages. Created SSRS reports and deployed them.
• Installed SQL Server 2014 in Amazon cloud AWS. Set up 2014 AlwaysOn Availability Group on Windows cluster.
• Migrated 2008R2 SQL Server failover Cluster to SQL Server 2014 AlwaysOn Availability Group.
• Set up transactional replication and log shipping for databases in AlwaysOn Availability Group.
• Supported SQL Server transactional replication and log shipping replication.

Confidential, Jersey City, NJ

Microsft SQL DBA and Oracle DBA

• Installed SQL Server 2008, 2008R2 and 2012 on VMs. Migrated SQL servers from physical machines to VMs.
• Upgraded SQL Server from 2005 to 2008R2, and from 2008, 2008R2 to 2012.
• Troubleshoot and worked with MS support enginners to fix the SQL Server Browser service hung problem.
• Configured and set up a log shipping standby databases for a critical applicaton.
• Troobleshot application query performance problems, analyzed query execution plans and resolved the issues.
• Made a SQL Server inventory analysis by using Microsfot MAP TOOL.
• Produced a VM inventory report by querying VMware Virtual Center database.
• Configured and created a linked server from a SQL server to a Composite database.

Oracle DBA

Confidential

• Detected and fixed an Oracle data block corruption problem. Recovered all data from the corrupted block.
• Investigated and resolved the existed Netbackup RMAN restore problems.
• Installed and configured Oracle Enterprise Manager 12c Cloud Control with databse on a Linux cluster and applications on a Linux VM.
• Migraded Oracle Instances from HP UNIX clusters and Window platforms to Linux clusters.
• Troubleshot and resolved a few Confidential performance problems.

Confidential, New York

Oracle DBA and Oracle Apps DBA

• Upgraded Sybase servers from version 12.5 to 15.5, and from 12.5 to 15.7.
• Redesigned and implemented data population from production Sybase servers to Sybase report server.
• Created scripts to populate Oracle data to the Sybase report server by using Sybase Enterprise Connect to Oracle and Sybase proxy tables.
• Performance tuning. Adjusted configuration parameters to reduce contention within server processes. Configured data cache with different I/O size of memory pools.
• Failed over production Sybase servers to DR and Failed back to new production Data Center to support production Data Center migration from NY to NJ.
• Created and supported Sybase Replication Servers 12.5 and 15.5.
• Set up and supported Sybase replication for Warm Standby application.
• Set up a table replication by create replication definition and create subscription.
• Used Sybase showplan to troubleshot query performance problem. Helped user to create better indexes. Set up update statistics jobs and rebuild index jobs to run regularly.
• Using DMA to determine the Wait Event for the long running process, to find the SQL text.
• Created proxy tables for Sybase users to access tables in other Sybase servers.

Confidential

Microsoft SQL Server

• Created linked server to Sybase, Oracle, and other Microsoft SQL databases. Designed and Created backup and maintenance jobs for production databases. Created a job to load production database backups to DR databases automatically. Supported user managemants and space managements etc.
• Setup and Supported MS SQL server clusters, replication and log shipping.
• Installed and supported SSIS, SSAS and SSRS.
• Migrated SQL server 2008R2 from physical hosts to Virtual Machines.
• Upgraded SQL server 2000, 2005 to SQL Server 2008R2 and 2012.
• Supported Data Center migration from NY to NJ. Failed over all MS SQL servers from production to DR, and failed back to new Data Center to support production Data Center migration
• Helped our clients to troubleshoot their application problems, performance problems. Used Microsoft SQL Profiler to help user troubleshoot performance problem.

Oracle Apps DBA

Confidential

• Upgraded Oracle E-business Suite from version 11.5.10.2 with database 10g to version 12.1.3 with database 11gR2.
• Migraded Oracle E-business Suite database from UNIX platform to Linux platform.
• Migraded Oracle E-business Suite 11.5.10.2 database tablespaces to OATM(Oracle Applications Tablespace Model).
• Migraded Oracle E-business Suite from two nodes installation with database, Admin, Concurrent Manager on one node, and Web server, Forms on the other node to two nodes installation with database on a Linux node, and all applications on an Unix node.
• Created project plans for all upgrade and migration tasks and worked with users to execute the tasks in steps.
• Configured and supported Oracle Workflow Mailer in Oracle Applications 11i and R12.
• Developed a monitoring script to monitor Oracle Workflow Mailer.
• Designed and set up our DR environment for Oracle E-business Suite. Successfully failed over and failed back our Oracle EBS Applications to DR site during the severe production problem and in our Data Center relocation process.
• Developed scripts to automatically clone our Oracle EBS production environment to QA environment daily.
• Performance tuning for Oracle Applications. Resolved the performance issue with Add/Delete Summary Templates job in both version 11.5.10.2 and 12.1.3.
• Cloned Oracle EBS environment in versions 11.5.7, 11.5.10.2 and 12.1.3.
• Upgraded Oracle EBS Financials from11.5.7 to 11.5.10.2 which includes upgraded Oracle server from 9.2.0.6 to 10.2.0.4 and also from 32 bit to 64 bit . Applied Oracle Application Technology 11i.ATG.PF.H.RUP7.
• Applied various patches to Oracle Financial Applications. Analyzed Oracle patches.