Gurpreet Saini

Database Administrator (DBA)

Dallas, TX

ac696c@r.postjobfree.com - 972-***-****

● 5+ years of IT experience in Database Administration, Development & Support of MS SQL Server 2016/2014/2012/2008R2/2005/2000.

● Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

● Expertise in Migrating/Upgrading SQL Server 2012 to 2014 and from SQL Server 2014 to 2016.

● Extensive experience in installation, configuration and administration of MS SQL Server 2016/2014/2012/2005/2008R2.

● Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications.

● Experience in administering the created reports and assigning permission to the users for executing the reports.

● Perform monitoring, administration & troubleshooting of SQL databases.

● Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail agent.

● Implemented Backups and Restore strategies using Native SQL and Light speed 3 rd party tools.

● Developing, Implementing and maintaining Data warehouse, Using tools like MS-SSIS and MS-Reporting Services.

● Monitored and debugged various bottlenecks through a Spotlight 3rd party monitoring tool.

● Backup & Recovery management using various customized T-SQL scripts and GUI.

● Performed Log Shipping and implemented Replication as High Availability techniques.

● Expertise in Always-on Availability Groups(AAG) and HA/DR setup.

● Working knowledge of Database Mirroring.

● ETL using SQL Data Transformation Services, Integration services and Automation of jobs for administration and applications.

● Experience in creation of logins, users and configuring permissions and assigning roles to users.

● Hands on Reporting Services development and implementation experience.

● Ability to work in a fast-paced team environment, to administer and support 24x7 database systems.

● Self-motivated, with ability to meet deadlines.

TECHNICAL SKILLS

Database MS SQL Server 2016/2014/2012/2008 R2/2008/2005/2000, Oracle 10g/11g.

Programming

Languages

T-SQL, SQL, PL/SQL

Operating Systems Windows XP/Vista/7/8/10

Tools SQL Server Management studio, SSRS, SSIS, MS-SQL Profiler,Spotlight,Litespeed

Scripting Languages HTML.

Education:

MCA(M asters of Computer Application) From Punjab Technical University Jalandhar, India. BCA ( Bachelor of Computer Application) From Punjabi University Patiala, India. Certification:

MCTS: SQL SERVER 2008, IMPLEMENTATION AND MAINTENANCE W ork Experience

Database Administrator

Database Version: Microsoft SQL Server 2014/2016

Incomm,Inc-Dallas, TX

Oct 2016 to Feb 2018

Responsibilities:

● Designed and implemented comprehensive Backup plan and disaster recovery strategies.

● Implemented and Scheduled Replication process for updating our parallel servers.

● Created Logins, Users and Roles in context of SQL Server security.

● Created procedures, functions and triggers.

● Used stored procedures and views to allow users to access data instead of letting them directly access tables.

● Designed and implemented Backups and Restore strategies using Native SQL and Light speed 3 rd party tools.

● Installed, configured and supported SSRS

● Configure log shipping for multiple databases as a part of disaster recovery.

● Monitored and debugged various bottlenecks through a Spotlight 3rd party monitoring tool.

● Created reports using SQL Server Reporting services.

● Perform SQL Server service pack and Windows Service pack upgrades.

● Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test and production environments.

● Responsible to install & Configuring SQL Server software.

● Implemented and maintained high availability systems(clustering, log shipping)

● Restored database in case of failure or whenever required by applying full database backup and transaction log backups.

● Provide 24/7 technical database support for SQL Database systems.

● Give users the least amount of permissions they need to perform their job. Environment: SQL Server 2014/2016, SSRS.

Database Administrator

Database Version: Microsoft SQL Server 2012

Performing Arts Fort Worth

March 2016 to Sep 2016

Responsibilities:

● Responsible for Database Backup and recovery/Restoration, Scheduling Jobs.

● Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

● Designed and created databases, tables,views, stored procedures and triggers.

● Used stored procedures and views to allow users to access data instead of letting them directly access tables.

● Installed, configured and supported SSRS

● Created reports using SQL Server Reporting services.

● Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test and production environments. Environment: S QL Server 2012, SSRS.

Database Administrator

Database Version: Microsoft SQL Server 2014/2012/2008 Natsoft Corporation, New Jersey

Nov 2014 to Feb 2016

Responsibilities:

● Performed routine DBA activities.

● Worked on supporting environment which in High Availability (HA) and DR

● Supported Systems in Clustered, Log Shipped and Mirrored environment

● Created Logins, Users and Roles in context of SQL Server security.

● Created procedures, functions and triggers.

● Export or Import data from other data sources like flat files using Import/Export wizard.

● Responsible for Database Backup and recovery/Restoration, Scheduling Jobs.

● Migrated SQL Server 2008 to 2012 and SQL Server 2012 to 2014.

● Responsible for general Database Administration and Performance.

● Used stored procedures and views to allow users to access data instead of letting them directly access tables.

● Installed, configured and supported SSRS

● Give users the least amount of permissions they need to perform their job.

● Configured Transactional Replication and Log Shipping with SQL Server Management Studio.

● Created reports using SQL Server Reporting services.

● Responsible to install & Configuring SQL Server software.

● Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test and production environments.

● Review all nightly processes for successful completion.

● Replicating the SQL Server to transfer and update data at remote servers, setting up of Transactional replication, created publisher database, distributor database and push & pull subscriber databases.

Environment: S QL Server 2014/2012/2008, Log Shipping, Replication, Cluster, SSIS, SSRS. Database Administrator

Database version: Microsoft SQL Server 2012/2008

Gill Financial Corp, Calgary Canada

May 2012 to Oct 2014

Responsibilities:

● Responsible to install & Configuring SQL Server software.

● Implemented and monitored user access and security.

● Coordinating with application programmers to write stored procedures.

● Give users the least amount of permissions they need to perform their job.

● Created Logins, Users and Roles in context of SQL Server security.

● Managing multiple servers.

● Created reports using SQL Server Reporting services.

● Creation of Database Objects includes: Tables, Stored Procedure, Views, Triggers, Index &function.

● Performing monitoring using query profiler.

● Performing monitoring using query profiler.

● Database Backup and recovery/Restoration, Scheduling Jobs.

● Review all nightly processes for successful completion.

● Created SSRS reports

• Migrated server from MS SQL Server 2005 to MS SQL Server 2008.

• Database Backup and recovery/Restoration, Scheduling Jobs. Environment: S QL Server 2012/2008/2005, Log Shipping, Replication, Cluster, SSIS, SSRS. Database Administrator

Database version: Microsoft SQL Server 2008 and oracle 11g Nexen Inc., Calgary Canada

Nov 2011 to April 2012

Responsibilities:

● Implemented and monitored user access and security.

● Database Backup and recovery/Restoration, Scheduling Jobs.

● Restored database in case of failure or whenever required by applying full database backup and transaction log backups.

● Troubleshooting problems by using SQL server profiler.

● Created reports using SQL Server Reporting services.

● Created procedures, functions and triggers.

● Performed routine DBA activities.

● Give users the least amount of permissions they need to perform their job.

● Conducted and managed full and incremental database backups via RMAN.

● Configured Transactional Replication and Log Shipping with SQL Server Management Studio.

● Responsible for general Database Administration and Performance.

● Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test and production environments.

● Used stored procedures and views to allow users to access data instead of letting them directly access tables.

Environment: S QL Server 2008, Log shipping, Replication, Cluster, SSIS, SSRS, Oracle 10g. Database Administrator

Database Version: Microsoft SQL Server 2000/2005/2008 and Oracle 10g/11g Dutta Webtech, Chandigarh India

June 2007 to May 2008

Responsibilities:

● Responsible to install & Configuring SQL Server software.

● Hands on experience in creating SQL scripts to automate the database processes.

● Created Reports using MS-Reporting Services.

● Conducted and managed full and incremental database backups via RMAN.

● Coordinating with application programmers to write stored procedures.

● Creating Jobs and DTS Packages.

● Used stored procedures and views to allow users to access data instead of letting them directly access tables.

● Give users the least amount of permissions they need to perform their job.

● Created Logins, Users and Roles in context of SQL Server security.

● Managing multiple servers.

● Creation of Database Objects includes: Tables, Stored Procedure, Views, Triggers, Index &function.

● Enhancing query by dropping poorly involved indexes with new indexes.

● Performing monitoring using query profiler.

● Database Backup and recovery/Restoration, Scheduling Jobs.

● Review all nightly processes for successful completion.

● Worked on two node Active Passive clustering in SQL server 2005. Environment: S QL Server 2008/2005/2000, Log shipping, Replication, SSIS, SSRS, Oracle 10g.

Contact this candidate