SUMMARY

• 8 plus yrs of IT experience in Design, Development, and 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 wif MSSQL SERVER 2005, 2008 and 2008R2 features and extensive noledge on SQL 2012/2014 new features.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators wif 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, me/O, Memory bottlenecks.
• Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
• Worked on logical and physical data base modeling wif UML and ERWIN tools.
• Expert in data transformation services and Bulk Loads wif SSIS and BULK INSERT ETL operations.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals 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 wif ability to co-ordinate activities and work in a team environment to meet the 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 TEMPeffectiveness SQL Server databases. The applications and associated databases track worker activities throughout the day and allow management to review and use the data to improve productivity. The primary database application me supported TEMPhas 20,000+ users who daily and in real-time record all their work.
• Migrated the primary database from a SQL 2008 physical server to a VMware SQL 2012 AlwaysOn AG Cluster.
• Configured the Cluster for read-only routing to the 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 halped implement SSIS processes to cleanse the 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 the indexes at regular intervals for better performance.
• Recovering the 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 the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This 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 the stored procedure, designing, coding and developing the same using the T SQL Programming.
• Transferring the 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 the 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 the maintenance of large tables to resolve performance issues.
• Optimize the 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 the packages using Package Deployment Model and deploy the packages into production environment by using Integration Services Catalogs.
• Troubleshooting Application issues using SQL Profile Trace.
• Analyzing long running slow queries and tuning the same to optimize applications and system performance using IDERA.
• Backup and recovery of production databases on daily /weekly basis to ensure data integrity, striping the 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 the 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, authentication, 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 the business requirements using advanced SQL functions such as Rank(), CTE, Dynamic SQL Queries and Table valued functions etc.,
• Developed ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files) and loaded the 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 the data as needed, and loading the finished data into the cube.
• Monitoring and report generation for the 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 the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments when necessary.
• Created Transactional replication for the reporting apps.
• Implemented DR solution at the remote site for the production databases using Log Shipping.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used System monitor to find the bottlenecks in CPU, Disk me/O and memory devices and improved the 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 the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins wif the 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 the 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 the 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 wif 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 the development team before releasing them into the Production.

Confidential

MS SQL Server DBA

Responsibilities

• Installation of SQL Server 2000/2005
• Creating & Managing the 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 wif 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