Jatinder Singh

Email –adh75b@r.postjobfree.com

Cell - 732-***-****

SUMMARY

SQL Server DBA with 8 years of experience of IT with strong administration and implementation experience using SQL Server 2017/2016/2014/2012/2008R2/2008/2005/2000.

Experience in Database administration activities like Installation, Configuration,Backup & Recovery, Database security

Good knowledge Relational Database Management System (RDBMS).

Experience in providing Production Support for 24x7.

Experience in upgrading from MSSQL Server 2008/2012 to MS SQL Server 2017.

Expertise in Implementing High availability & Disaster Recovery solutions as Clustering, Always ON, Availability Groups,Replication, Log Shipping and Mirroring

Experience in implementing different types of Replication models like Snapshot, Peer to Peer and Transnational.

Experience in Maintenance plan for checking integrity, schedule with full and transaction log backup and other cleanup task

Created and Implement Backup Policy based on companies SLAs

Experience Troubleshooting Performance Issues

Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, Active monitoring, backup and restore procedures.

Experience migrating from On-Prem to SQL Azure

Experience Working with PostgreSQL & AWS

Good knowledge of Power Shell, Tableau and Power-Bi

Certification:

Certified PostgreSQL Administration Associate

Certified AWS Cloud Practitioner

MCTS – Microsoft Certified Technology Specialist

Professional Experience

MainTech, Cranford, NJ 7/2017 - 9/ 2020

SQL Server Database Administrator

Description: Maintech was founded in 1973 as a Third-Party Maintenance (TPM) company delivering IT Hardware Maintenance services to the Financial Services and Telecommunications marketplaces. Over the years, Maintech has evolved into a truly Independent Services Organization (ISO) delivering a comprehensive portfolio of single-source Managed Services for IT Infrastructure Support including Hardware Maintenance, NOC Monitoring, Server and Network Administration, Cloud Services, Help Desk, IT Asset Management/Destruction and much more.

Responsibilities:

Installed, configured, maintained and supporting SQL Server 2008, 2008 R2 and 2012,2017 in high availability environments.

Extensively involved in Upgrading SQL 2008R2 to SQL server 2016 in production.

Implemented Database Mirroring in SQL 2008R2/2012

Successfully implemented Log Shipping in SQL Server 2008/2012

Successfully Implemented and configured Mirroring and Always On.

Extensively worked on administration activities like Disaster Recovery, backup and restore.

Extensive Knowledge in Installation/Configuration/Administration of PostGreSQL database and fine tune them.

Migrated the PostgreSQL databases from on-perm to AWS EC2& RDS instances.

Successfully implemented Streaming Replication in PostgreSQL 11.7

Imported data from text files and excel spread sheets into SQL Server database using SSIS

Knowledge of migrating Databases from Physical server to SQL Azure

Migrated Servers to Wrklodz Environment

Automate Tasks using Batch files

Created Data marts for Power BI

Involved in performance tuning, optimization of stored procedures and queries

Performed Multiple successful Disaster Recovery Tests

Created templates for data feed.

Provided 24 x 7 Production support for the database and application issues.

Environment: MS SQL server 2017/2014/2012/2008/2008R2, Windows 2008/2012/2016 Server

Emblem Health, New York

SQL Server Database Administrator 12/12 to 07/25/16

Description - The GHI and HIP health plans administered by Emblem Health are among the most innovative and flexible in the industry. Groups and individuals can choose from a variety of accredited PPO, EPO and HMO health plans, as well as prescription drug, dental and vision coverage. Plan members get access to most of the tri-state area's top doctors and other medical professionals. Our members can also make use of acute care hospitals and physicians with hospitals across all 50 states. And the nearly 2.8 million people we serve — ranging from employees in small and large groups to individuals, public workers and retirees.

Responsibilities:

Installation, Configuration and Maintenance of MS SQL Server 2005, 2008, 2008R2, 2012.

Involved in resolving blocking and dead lock Issues by using SQL Build in tools

Migrated Databases from ON-Perm To SQL AZURE

Extensive worked on administration activities like Disaster Recovery, backup and restore.

Created & managed the Database Users, Login and Security.

Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.

Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. Troubleshooting high availability scenarios involving Database Mirroring, Log Shipping and Replication

Created and tested the linked servers

Successfully Implemented 2 Node Active\Passive clustering for production applications with multiple instances of SQL Server 2017/2012/2008R2.

Deploying database objects from development/testing environment to production environment.

Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.

Experience setting up database mirroring for production server

Responsible for Supporting Biz Talk Cluster Environment

Configured replication methods like snapshot, transactional and merge replications.

Imported data from text files and excel spread sheets into SQL Server 2005/2008 database using SSIS

Responsible in Monitoring and Troubleshooting SQL Server Performance issues.

Provided 24 x 7 Production support for the database and application issues.

Environment/Tools: SQL Server 2005/2008/2008R2, T-SQL, Enterprise Manager, Query Analyzer, Windows 2003/2008 Server, SSIS,SSRS,MS Excel and Windows XP, Idera Toolkit, VMware

U.S. Foodservice, Perth Amboy, NJ 10/2011 to 08/2012

SQL Server Database Administrator

Description: US Foods is one of America’s leading foodservice distributors to restaurants, healthcare and hospitality facilities, government operations and educational institutions. We offer more than 350,000 national brand products and our own high-quality private label items ranging from meats to produce to frozen foods.

Responsibilities:

Installation, Configuration and Maintenance of MS SQL Server 2005, 2008, 2008R2.

Involved in setting up Transactional Replication and Snapshot replication

Involved in Setting up Log shipping.

Extensively involved in database mirroring.

Extensive worked on administration activities like Disaster Recovery, backup and restore.

Created & managed the Database Users, Login and Security.

Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL.

Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.

Administrator tasks such as managing users, roles, and profiles.

Involved in resolving blocking and dead lock Issues by using SQL commands Using T-SQL.

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.

Created and deployed and scheduled report using SSRS.

Environment/Tools: SQL Server 2005/2008/2008R2, T-SQL, Enterprise Manager, Query Analyzer, Windows 2003/2008 Server, SSIS,SSRS,MS Excel and Windows XP, dera Diagnostic Manager

Contact this candidate