Jan Mohammed

Database Administrator

adkhh6@r.postjobfree.com

201-***-****

Professional Summary

Professional and highly motivated DBA with extensive experience in SQL on various business domains.

Expertise in installation of MS SQL Server 2017/2016/2014/2012/2008R2 and MySQL 5.6, 5.7.

Proficiency and expertise with Delphix environment in creating dsource and provisioning databases with the latest copy from production to Dev, SIT, UAT environments.

Proficiency and expertise in Migrating Database from SQL Server 2005/2008 to 2008R2/2012/2014/2016/2017 using side by side and in place migrations.

Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.

Expertise in SQL Server Backup/Restore, having knowledge of upgrading SQL Servers.

Worked on fine-tuning databases, created Clustered and Non-Clustered Indexes for tables, identified Fragmentation.

Experience with AWS Aurora in creating RDS instances to serve data through servers for responding to requests.

Implemented Amazon RDS multi-AZ for automatic failover and high availability at the database tier.

Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated on premises databases on Azure, deployed products on Azure, worked on development and test environment on Azure.

Implemented "Always on Availability groups" in SQL Server 2017.

Experience in regular maintenance activities like Query Tuning, Index rebuild/reorganize log file monitoring, temp Data Bases monitoring, handling blocking, deadlock resolutions, and fragmentation issues.

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions using MS SQL Server 2017/2016/2014/2012/2008R2.

Experience with SQL Server Database Administering high availability and Disaster Recovery Strategies using Clustering, Standby/Replication, Database Mirroring, Log shipping.

Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations.

Performance Tuning Application level for code, queries, Identify slow performing SQL objects and enhance for optimum database performance.

Experience in working with Managing Backups, Disk & Drive Space issues, managing indexes.

Provided on-call support 24x7 on a weekly rotational basis

Effective communication, presentation and interpersonal skills and good experience in handling Team as well as end users.

Education:

Master’s in Information Technology, New York.

Technical skills:

Databases: MS SQL Server 2017/2016/2014/2012/2008R2, MySQL 5.6/5.7,

Database Tools: Query Analyzer, SQL Profiler, Data Transformation Services, Performance Monitor, Tuning advisor, Replication, BIDS (SSIS/SSRS/SSAS), Dbeaver, Work bench.

Operating Systems: Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2008/2012/2016.

Languages: SQL, T-SQL.

Tools & Utilities: SQL Trace and SQL Tuning Advisory, SQL plus, ETL, MS- Excel, Visual studio code, Jira, Bitbucket, Git, Fog Light.

Third party tools: Litespeed, Delphix, Vormetric Encryption, Solar winds, Attunity Replicate, Splunk, Air Flow.

Ticketing tools: Servicenow, Iserve

Professional Experience

Client: Mass Mutual, Springfield, MA. Mar 2020 -Till Date

Role: Database Administrator

Project: SWIPR Application.

Description: Strategic Work-In-Progress Repository is the chosen strategy for sending transactions to the Omni record keeping system. SWIPR consists of a database which will hold transactions submitted on-line during the day and a batch process that will generate a file to Omni at the end of the business day. Financial transactions can only be submitted to Omni after the market’s close. After Omni processes the transactions, an Omni log file is sent back to MassMutual and is used to update Edwin with current values. The Omni log file will also be used to indicate those transactions on SWIPR which were sent to Omni as being completed.

Responsibilities:

Responsibilities include the Production and Application Support for the Database and Application Servers.

Configured and maintained the monitoring and alerting of production and corporate servers/storage using Cloud Watch.

Encrypted data on server side.

Set up Disaster Recovery (DR) in Aurora MySQL in the West Region.

Extensively worked using AWS services along with wide and in depth understanding of each one of them.

Implemented domain name service (DNS) through Route 53 to have highly available and scalable applications

Created RDS instances to serve data through servers for responding to requests.

Created snapshots to take backups of the databases in RDS

Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.

Installing, Configuring and Maintaining SQL Server 2017 (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.

Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.

Configured Always-On with synchronous and asynchronous secondary replicas.

Tune slow running queries using SQL Server Profiler.

Implemented and monitored different types of High Availability &Disaster Recovery scenarios like Always on Availability Groups, Replication models (Snapshot, transactional), Database Mirroring and Clustering.

Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.

Configured Active- Active, Active- Passive clustering (two node and multi node) on physical and virtual environments.

Write T-SQL Scripts for database backup jobs and daily/weekly jobs.

Optimized the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application.

Provided 24/7 on call support on a weekly rotational basis.

Environment: MS SQL Server 2017/201/2014, MySQL 5.6, 5.7 Service Now, Profiler, AWS Aurora.

Client: Molina Health Care, Long Beach, CA June 2018 -Feb 2020

Role: SQL Database Administrator

Project1: QNXT Upgrade 5.3 to 5.6

Description: QNXT Claims Workflow is part of the Cognizant line of TriZetto Healthcare Products, a portfolio of software products that help healthcare organizations enhance revenue growth, drive administrative efficiency, improve cost, quality of care and improve the member and patient experience. The application automatically manages, and routes claims in real-time to user work queues based on configured routing rules. QNXT users then quickly and efficiently move on to the next work item in their workflow queue. In this project we moved all the QNXT databases from 5.3 to 5.6 versions which is Azure.

Project2: Clinical Care Advance (CCA)

Description: Care Advance provides a single platform that transforms care management into a data-driven enterprise activity. Streamlining Disease, Case and Utilization Management allows you to deliver targeted health information and wellness campaigns more effectively, while getting the most out of interactions with members and providers. In this CCA project we moved the databases from On-Premises to Azure by testing in all the environments.

Responsibilities:

Administrated SQL Server 2017/2014/2012/2008R2/2008 databases in Production, Staging, QA and development environments.

Refreshed the Databases with the Latest copy from the production and provided it to the users for their testing environment with the help of Delphix.

Created the dsource of the database on the delphix environment from the production to refresh the databases for the users

Upgraded/Migrated SQL Server 2014 to SQL 2017 and migrated SQL databases to Azure SQL database in test and Dev environments.

Installed SQL Server 2017 Cluster and configured Always On availability group set up on Windows Server 2012R2 in Development production environments.

Configured Monitored Supported and Troubleshooting of Database Mirroring and Log shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery.

Managed Azure IaaS, creating VM and resource deployment and configuration.

Designed and implemented backup plans as per the data- retention policy outlined in the BRD.

Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics.

Migrated SQL Server databases to SQL server 2017 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.

Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.

Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Monitored the Performance of the SQL Server by using Performance monitor, SQL Profiler, Performance Analysis and Solar winds.

Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards.

Environment: SQL Server 2017/2016/2014/2012//2008R2, Windows NT/2008R2/2008/2003, Delphix, T-SQL, SSIS, and SSRS, Azure.

Client: Digital Construction Technology, LLC, Queens, NY. Jan 2017- May 2018

Role: Database Administrator.

Project: MS CHIP Project

Description: DCT is a privately held company in New York whose main target is to provide total health care, telecommunication, construction solutions and open new doors for all type of business. Mississippi Children’s Insurance Program was created with strong bipartisan support. CHIP gives states financial support to expand publicly funded coverage to uninsured children who are not eligible for Medicaid. In this Project, we used to provide the users with latest snap shots of databases when ever requested by them and used to take care of the issues related from the DBA end.

Responsibilities:

Installed SQL Server 2014 as failover cluster and standalone installation on windows server 2012R2 and 2016 64-bit OS and VM Ware in PROD/TEST/DEV.

Configured and Supported Always on Availability Groups for databases on SQL 2016.

Automated Dev/pilot/QA for quick refresh of VLDB from PROD using CommVault.

Monitored SQL instances with Zenoss and Fog light.

Used ServiceNow to complete tickets, raise Incidents and track changes.

Documented DEV/UAT/PROD server inventory.

Migrated SQL 2008/2008R2 to 2014/2016.

Fine-tuned slow running ETLs and T-SQL Queries.

Configured Native Log shipping and Database Mirroring.

Provided on call prod and application support on rotation basis.

Resolved application timeouts and slow running queries for critical client deliverables.

Developed post migration and pre migration steps and resolved post migration issues.

Environment: TSQL, MS SQL SERVER 2014, SSRS, SSIS, WINDOWS SERVER 2012R2/2016, Zenoss, Fog light, SSMS.

Client: Magazine3, Hyderabad, India. June 2012- Nov 2014

Role: Database Administrator.

Location: Hyderabad, India

Project: Payment Integrity Project

Description: Magazine3 is one of the premium Word Press themes development company. The company develops the themes in various categories like Health care, Newspaper, Technology, Gaming and more. Payment integrity is the process of ensuring that a health claim is paid correctly by the responsible party, for eligible members, according to contractual terms, not in error or duplicate, and free of wasteful or abusive practices. Payment integrity uses data mining and analytics to identify fraudulent, erroneous, or abusive claims, supports resolution with improved workflows, and promotes ongoing payment efficiency. In this Project we worked on refreshing the databases with the recent copy of databases from production in order to find the latest claims for the users.

Responsibilities:

Managing and administering SQL server instances which include 2008/2008 R2.

Migration and upgrade of databases from old versions to SQL Server 2008 and SQL Server 2008 R2

Performed database backups and restoration as needed.

Created SQL jobs for the backups on all the servers using a script.

Implemented partitioning on large table to get the performance.

Configured and worked on Database Mirrored Environments.

Involved in configuring Always on availability groups in SQL 2012.

Created database users same as login as well as different when requested.

Find and fixed Orphan users during the restoration of the database.

Created missing indexes on the tables by running Data Base Engine Tuning Adviser.

Optimized stored procedures to get the optimal performance.

Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans.

Expert in Performance Tuning of the Stored Procedures.

Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and updated statistics.

Deploy the reports on the servers where users can use.

Created stored procedures and Functions accordingly the requirement.

Implemented installation documents for the future reference.

Environment: MSSQL Server 2008 R2, 2008, 2005 and 2000, T-SQL, SSIS (ETL), SSRS, Erwin, Windows 2008 R2 Server, SharePoint.

Contact this candidate