SQL Database Adminstratir

A Microsoft Certified, aspiring for a job in an esteemed organization with challenging atmosphere where my talent can be utilized for maintaining, developing and supporting several IT Projects.

SUMMARY:

In-depth understanding of relational database (SQL) components like Normalization, OLAP, OLTP.

Conceptual knowledge of SQL High Available and Disaster recovery techniques like Replication, AlwaysON Clustering & Availability Groups.

Familiar with database schema and corresponding objects which can be part of it along with DDL, DML, DCL commands.

Good understanding of SQL Tables, Indexes, Stored Procs and Functions.

Experience with assigning server\database\application specific granular permission to different users.

Good with writing T-SQL queries using JOINs.

Worked on native SQL troubleshooting and monitoring tools like SQL Profiler Trace, Extended Events, Policies & Alerts etc.

Can work efficiently on various SQL versions like SQL 2012 and 2014.

Thorough knowledge of SQL Backup operations like FULL, T-Log and Differential backups and Restore operations like WITH RECOVERY, NO RECOVERY and STANDBY mode.

Familiar with different component\services on SQL Server like SQL Server Integration Services, SQL Server Browser Services, SQL Upgrade Advisor etc.

Hands on experience of recovering the data using Backup & Restore operations.

Aware of different server and database configurations settings like Database Growth, Max DOP, MIN & MAX Memory setting etc.

Understanding of concepts of Database Integrity and ways to enforce as per business requirements using different forms of Keys, Constraints and Triggers.

Good communication skills and ability to adapt to the environment.

Will maintain positive communication and working relationship at all business levels.

TECHNICAL SKILLS:

Windows (XP, 7 & 8), SQL Server 2008, 2012, 2014, Microsoft Office components (Outlook, Word, Excel and PowerPoint)

EDUCATION:

Bachelor of Arts (Mathematics), Punjab University, India 2005

Bachelor of Education, Punjabi University, India 2006

CERTIFICATION:

Microsoft SQL Server 2012\2014 Administration (70-462) 2017

WORK EXPERIENCE:

1.Junior SQL DBA\SSIS Developer (Remote Project) Feb 2017-Present

Partners Healthcare, Boston MA

Helping with day-to-day DBA tasks like Monitoring Backup & SSIS Package Job executions.

Notifying application developers about failed Job which include SSIS packages.

Creating Alerts notifying Job failures during off business hours and weekends.

Assisting Senior DBAs to write SQL queries to be used in reports run against DW databases.

Executing T-SQL scripts under different environments and supporting non-critical PROD deployments.

Restored databases in lower environments from production backups on demand.

Creating new & Updating current Users with granular permissions on Object level.

Assisting Senior DBAs with upgrading SSIS packages from SQL 2008 to SQL 2012 server using SQL Server Data Tools.

Managed database and object level permissions on SQL Users.

Supported PROD deployments for various applications.

Deploy upgraded SSIS packages to SQL 2014 SSIS File System.

Familiar with different SSIS Package tasks and Integration Services Catalog.

Grade 8, 9 &10 Teacher

Government High School, Punjab India 2006-2009

Supervised classes for grade 8, 9 and 10.

Developed a study program to help students understand mathematical concept like Algebra, Geometry, Trigonometry, Arithmetic etc.

Encouraged students to participate in extra curriculum activities like interschool GK competitions, street plays (educational) etc.

Accessed student’s abilities and conducted Parent-Teacher meetings to communicate student’s monthly performance.

Evaluated and recommended students for monthly scholarships.

Facilitated school administrative tasks like managing Scholarship funds, coordinating fund raising for classroom improvement activities.

Contact this candidate