SUMMARY

• 8 plus yrs of IT experience in Design, Development, Implementation & Administration of Client - Server Applications & Database systems using MSSQL 7.0/2000/2005/2008/2008R2/2012/2014/2016 applications in all SDLC environments.
• Experience in Installation and maintaining of different version of SQL Servers (2016,2014, 2012, 2008R2/2008/2005/2000) in both OLTP and OLAP lower regions and Production environments and hotfixes service packs on standalone and clustered Servers.
• Implemented High Availability & Disaster Recovery techniques like Always ON Availability Groups, Clustering (Both Active-Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping.
• Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012/2014.
• Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014 new features.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.
• Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon, Idera, RedGate, LightSpeed,
• Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to teh requirement.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Implemented teh new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security TEMPprincipals and AAG.
• Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.
• Documenting procedures in runbooks.
• Involved in installation and administration of Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS).
• Involved in designing SSIS /DTS packages to import and transform Data between databases and external data sources.
• Experience in Extraction & Migration of data from Heterogeneous Data sources like Excel, MS Access, Oracle, DB2 to MS SQL server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Involved in migrating DTS packages to SSIS packages and troubleshooting migrating issues.
• Performed Backup and restore of SSAS cubes.
• Involved in Reporting services Administration by creating roles, users and providing security to reports.
• Experienced in enterprise reporting in generating reports using Linked Reports, Sub Reports, Adhoc Reports, drill down reports, Drill through reports and filters, charts in SQL server reporting services.
• Excellent communication and interpersonal skills with ability to co-ordinate activities and work in a team environment to meet teh deliverables.

TECHNICAL SKILLS

Relational Databases: Sql server 2014/2012/2008R2/2005/2000/7.0, MS-Access 2000/2003/2007, Oracle 10g, My SQL4/5.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages: C, C++, C#, JAVA, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL.

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate, Sqlcompare, lite speed.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

MS SQL Server DBA

Responsibilities:

• Managed workforce effectiveness SQL Server databases. Teh applications and associated databases track worker activities throughout teh day and allow management to review and use teh data to improve productivity. Teh primary database application I supported TEMPhas 20,000+ users who daily and in real-time record all their work.
• Migrated teh primary database from a SQL 2008 physical server to a VMware SQL 2012 AlwaysOn AG Cluster.
• Configured teh Cluster for read-only routing to teh secondary replica node for heavy SSRS reporting.
• Installed SQL Server 2012 RTM on Amazon RDS EC2 (AWS) in Test Server.
• Removed nearly two Terabytes of unwanted old data and helped implement SSIS processes to cleanse teh data daily.
• Refined and implemented new views and SSIS data feeds for external business partners and data warehouse.
• Involved in Huge Database Migrations for Bank Several Districts Object Stores and analyzed legacy systems and databases to support data store FileNet Servers.
• Improved database performance by adding missing indexes, reviewing queries and assessing instance configuration.
• Upgraded SQL server databases from 2008R2 to 2014.
• Created and updated data verification plans and expected outcomes to be used for script runs.
• Involved in creating new and Modifying SSIS Packages for different business object stores.
• Rebuilding / monitoring teh indexes at regular intervals for better performance.
• Recovering teh databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing teh snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. dis involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Using BCP to Bulk copy data
• Implementation of Logins, creating assigning responsibilities as a part of Security Policies for various categories of Users.
• Restructuring teh stored procedure, designing, coding and developing teh same using teh T SQL Programming.
• Transferring teh data (ETL) by SSIS.

Confidential, Tulsa

MS SQL Server DBA

Responsibilities:

• Responsible for Logical & Physical Database Design.
• Experience in Handling 70+ Production Servers out of 10 Servers are having 1- 2 TB Databases.
• Migrated Huge databases of 5 TB from SQL server 2008R2 to 2012.
• Built Extended Events tool mechanism for BI Servers on SSAS platform.
• Experience in handling Tivoli TSM Tool for database backups.
• Handled Capacity Planning for Crucial Servers which are of 2TB databases.
• Experience in Resolving teh Memory contentions using SQL Min/Max Settings, SQL 2008 Resource governor and Lock pages In Memory settings,Page File settings, Memory related DMV’s
• Identify deadlock, blocking scenarios and Perform Re indexing and Index defrag operations for teh maintenance of large tables to resolve performance issues.
• Optimize teh TempDB performance by striping and move to dedicated SAN.
• Assisted in Installation and Support of Transactional Replication.
• Experience in Handling High Availability Log shipping.
• Handled Database Refresh in QA-Test and stage environment and fixed orphaned users.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, CTE and business rules using T-SQL.
• Convert teh packages using Package Deployment Model and deploy teh packages into production environment by using Integration Services Catalogs.
• Troubleshooting Application issues using SQL Profile Trace.
• Analyzing long running slow queries and tuning teh same to optimize applications and system performance using IDERA.
• Backup and recovery of production databases on daily /weekly basis to ensure data integrity, striping teh backups to ensure easy backup management.
• Capacity Planning for Crucial Servers in Production Environment.
• Perform database monitoring data and log growth, Jobs, Alerts, disk usage and cleanups, using various custom scripts in SQL Server Agent jobs, setup of Database Mail /operators for alerting.

Confidential, Houston, TX

MS SQL Server DBA

Responsibilities:

• Performed aspects of database administration, including data modeling, backups and recovery, Security Issues such as creation of various Objects and granting permission to user(s), role(s).
• Analyzing long running slow queries and tuning teh same to optimize applications and system performance. Performing DBCC checks.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Overall database design, such as creating normalized databases, autantication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types using T-SQL statements.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build and fixed orphaned users
• Developed Complex Stored procedures, functions, Cursors, Trigger and Views as per teh business requirements using advanced SQL functions such as Rank(), CTE, Dynamic SQL Queries and Table valued functions etc.,
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded teh data into target tables by performing different kinds of transformations using MS SQL Server Integration Services.
• Used Data Transformation Services to extract data from source databases, transforming teh data as needed, and loading teh finished data into teh cube.
• Monitoring and report generation for teh database infrastructure. These reports are presented to management on regular basis.

Confidential, Burlington, VT

MS SQL Server DBA

Responsibilities

• Performed server installation and configuration for SQL Server 2005 and SQL Server 2000.
• Performed installation of SQL Server Service Packs.
• Upgraded databases in SQL Server 2000 to SQL Server 2005.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for teh user created and system databases in teh production environment using teh Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments when necessary.
• Created Transactional replication for teh reporting apps.
• Implemented DR solution at teh remote site for teh production databases using Log Shipping.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update teh index statistics on teh production databases.
• Used System monitor to find teh bottlenecks in CPU, Disk I/O and memory devices and improved teh database server performance.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used Index tuning wizard to redesign and created teh indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined teh server/database level security by creating teh Windows and SQL logins with teh appropriate server/db roles and object level permissions.
• Extensive use of DDL and DML Triggers to implement business logic and for auditing changes to critical tables in teh database
• Checked code for ANSI standards using Standard Code Checker Tool
• Developed SSIS packages, scheduled them as jobs and deployed packages in SQL Server Integration Services
• Developed customized reports using SSRS and administered teh SQL Server Report server
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked on upgrading DTS packages to SSIS packages.
• Creation of various data objects like tables, views and indexes.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from teh development team before releasing them into teh Production.

Confidential

MS SQL Server DBA

Responsibilities

• Installation of SQL Server 2000/2005
• Creating & Managing teh Databases
• Creating Jobs and Maintenance Plans
• Backing up and recovering of data
• Creating Index and Managing
• Managing database users and security
• DB space issue like expanding DB file size, shrinking files, dealing with tempdb full
• Importing and exporting SQL related files
• Writing SQL Queries & Stored Procedures.
• Log Shipping, Mirroring and Replication
• Migration of database from SQL 2000 to SQL 2005
• Applying Service Packs to SQL Servers