Sql Server Database

Nazia Shaik

SQL Database Administrator

Email: **********@*****.***

Phone: 201-***-****

Around 8 years of professional experience in IT industry as a SQL Database Administrator in windows platforms. Experience includes System Analysis, Design and Development and Support of Microsoft SQL Server 2014/2012/2008R2/2008/2005/2000 on various business domains like Banking, Financial and Health.

Experience Synopsis:

Expertise in installation of MS SQL Server 2014/2012/2008 R2/2008/2005/2000 and updating with latest Hot fixes, Security Patches, Service Packs.

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

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

Hands on experience and outstanding knowledge on High availability &Disaster recovery solutions-Log Shipping, Mirroring, Replication and Clustering.

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

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

Expert in Data Integrity, Performance Tuning, Query Optimization.

Experience in PowerShell scripts and PowerShell active directory with SQL server PowerShell extensions.

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.

Strong in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.

Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them and implemented the security policies.

Experience in database upgrades and applying software patches to databases as per application/client requirements.

Closely worked with development team to assist them in various problems solving and troubleshooting applications and Database objects like stored procedures, functions, triggers.

Experience in developing T-SQL (DDL, DML, and DCL) statements.

Extensively used third party tools like Lite Speed, Fog light and Red gate.

Using DBCC Commands ensuring integrity of the databases.

Proficiency on design, construction and implementation of Business Intelligence tools (Star schema

Data-Warehouses, OLAP, OLTP, ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Reporting Services (SSRS) and SSIS.

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

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

EDUCATION:

Bachelor’s in Computer Science, JNTU

Technical Skills:

Databases

MS SQL Server 2000/2005/2008/2008-R2/2012/2014, Oracle 10g

Database Tools

Query Analyzer, SQL Profiler, Data Transformation Services, Performance Monitor, Tuning advisor, Replication, BIDS (SSIS/SSRS/SSAS)

Operating System

Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2000/2003/2008/2012/2014.

Languages

T-SQL, C, C#, Power shell

Tools & Utilities

SQL Trace and SQL Tuning Advisory, SQL plus, ETL, MS- Excel, Visual studio

Third party tools

Spot Light, Red gate, Idera, Light speed, Fog Light, SQL sentry

Professional Experience:

Sunrise systems Inc, Edison, NJ February 2016 – Present

Role: Senior SQL DBA

Responsibilities:

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

Upgraded/Migrated SQL Server 2008 databases to SQL Server 2008R2/2012 using side by side migration.

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

Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

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

Installing, Configuring and Maintaining SQL Server 2012/2008R2/2008 (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 (Local & Geo\Multi Site).

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

Implemented Database Mirroring and Transactional Replication as a part of DR plan.

Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2012/2008.

Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.

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

Configured Transactional replication from multiple publishers to one subscriber.

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.

Transferred data (ETL) to Data ware house Environment using SSIS.

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

Environment: MS SQL Server 2008/2008R2/2012/2014, SQL Sentry, Service Now, Profiler, Visual Studio Management, SSIS

Medline Industries Inc. – Broadview, IL October2014- January2016

Role: Senior SQL DBA

Responsibilities:

Managing and administering SQL server instances which include2008/2008 R2/2012.

Migration and up gradation of databases from old versions to SQL Server 2008 R2 and SQL Server 2012.

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.

Used table hints in the queries to avoid locks in the server

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 SSIS new packages and modified existed packages.

Upgraded few of the SSIS packages from SQL 2008 to SQL2012.

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.

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

Created Reports through Reporting server (SSRS) accordingly the business requirement.

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 2012, 2008 R2, 2008, 2005 and 2000, T-SQL, SSIS (ETL), SSRS, Windows 2008 R2 Server

Employment Security Department, State of Washington, WA

Feb2013- Sep2014

Role: SQL DBA

Responsibilities:

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

Managing all aspects of physical SQL Server database administration which includes security setup and enforcement, installations, upgrades, patching, troubleshooting and tuning.

Implement and maintain database security (create and maintain logins, users, roles, assign privileges)

Configured, monitor and troubleshoot efficient Disaster Recovery Strategies and High availability solutions include Clustering, Log shipping and Database Mirroring.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.

Troubleshooting of site issues, DB Performance issues and long running queries.

MS SQL Server database administration, configure Scheduled Tasks for regular Database Backup and Maintenance Activities.

Planning, implementation and support of database backup, database recovery and disaster recovery policies of databases in a highly availability environment.

Expert in Performance Tuning of the Stored Procedures.

Checking Database Health by using DBCC Commands and DMVS.

Monitored and modified Performance using execution plans and Index tuning.

Experience in Database security and integrity planning.

Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.

Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Manage regularly scheduled backups and occasionally a database recovery.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Supports several application and support teams with numerous on-going projects to create or improve application environments.

Participating in 24x7 on call primary pager support.

Environment: SQL Server 2000, 2005 and 2008, Windows Server 2000\2003\2008, SQL Profiler, Lite Speed Backup software, SSRS, SSIS.

Corporation Bank, Pune, India. August 2010 - November2012

Role: SQL DBA

Responsibilities:

Controlling day to day activities of Production database and troubleshooting the issues.

Performance tuning operations like Load balancing, Archiving, Indexing, Query optimization, performance monitoring.

Index Defragmentation by Rebuild/Reorganize of Indexes across all Databases.

Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005, 2008 databases including DTS to SSIS migration.

Archive & drop the decommission application related databases, jobs, packages without effecting other applications to compliance with bank policies.

Strong understandings of database schema object management.

Performance monitoring, Database and SQL tuning.

Performed database Backups and Recovery, as needed.

Provided in-depth consulting services in the identification and resolution of database issues in a timely and professional manner.

Provided support to development team on infrastructure and DBA Support.

Good communication skills, as needed to communicate effectively with different groups.

Designed and implemented Disaster Recovery sites using Mirroring and Log Shipping.

Resolved database performance issues, database capacity issues, replication, and performance tuned the stored procedures for optimal efficiency using execution plans, profiler traces and database engine tuning advisor

Created and implemented best backup, recovery strategies and re-indexing process Online banking servers.

Performed DBCC and DMV commands to troubleshoot issues related to database performance consistency.

Developed and assisted in Analysis services cubes, stored procedures, user defined functions, indexes and indexed views.

Environment: SQL Server 2000/2005/2008, T-SQL, Windows 2003/2008 server, Oracle 10g, Power Shell, SSIS.

Life Insurance Corporation ltd. - Chennai, India Feb 2009 - July 2010

Role: SQL Developer/ DBA

Responsibilities:

Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).

Created Stored Procedures, User defined functions, Views and Wrote T-SQL codes maintaining query standards for the project.

Created ER diagrams

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.

Involved in Optimization and normalization of database and tables.

Part of team for analyzing and implementing the physical design for database.

Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.

Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.

Designing and building data load procedures, using MS SQL Server.

Tune the SQL queries using SQL Profiler.

Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.

Environment: SQL Server 2000, Visual Studio Management, Transact-SQL, Query Analyzer, MS Access and Windows 2003.

Contact this candidate