Summary:

• 7 years of total IT Experience in Database Administration, responsible for developing customized business applications, database design, Leading projects and building large public domain databases.
• Experience with SQL Server 2005/2008/2012, database administration in Windows XP/7 and UNIX environments.
• Installation, configuration, creation and upgrades to SQLServer2008/2012 environments using Windows XP/NT servers.
• Experience with database backup, restore and disaster recovery procedures.
• Experience as on - call 24x7 production DBA support, application/development DBA.
• Hands on experience of database backups and recovery.
• Experienced in all facets of the systems development lifecycle from requirement development, architecture design, testing and post implementation revisions.
• Monitoring and optimizing the Performance of the database, turning Management, Change Management, capacity planning, and SQL tuning.
• Working experience with Very-Large databases (VLDB), data migration across different databases.
• Involved in replication setup, configuration and maintenance of replication process.
• Have exposure to application areas like Materials Management, Manufacturing, Security, Travel and Healthcare Domain, Communication and Control Systems and good understanding of business processes.
• Excellent Communication, interpersonal skills, leadership qualities (having led team of 3-15 members in 3 different projects). Possesses strong analytic and problem solving skills. A committed team player. Quick learner and always eager to take up challenging assignments.
• Implemented SQL Server 2008/2012 capacity planning, partitioning, performance and scalability, best practices for a high transaction throughput, mission critical system. Produced a big improvement in performance with respect to the queries, generating reports and huge inserts. Did setup and tested the disaster recovery environment.
• Lead multiple performance-tuning projects for databases that drive public, high traffic websites. Each project involved analysis of the application design, data model, Transact-SQL best practices, databases and SQL Server instance settings.
• Defined and implemented best practices and maintenance standards for a very large library system supporting many universities. Implemented monitoring and high availability with the use of clustering, replication and standby servers. Defined disaster recovery plans for 100+ SQL Server, environments.

TECHNICAL SKILLS

RDBMS: SQL SERVER 2012/2008R2/2008/2005..

Database tools: SQL SERVER Management studio, Enterprise manager, SQL profiler, Query analyzer Index analyzer, security manager, service manager SQL Agent, replication tool, backup server.

Reporting tools: SSRS, (SQL Server Reporting Services)

Data Modeling Tools: MS Visio, Erwin.

Programming Languages: T-SQL Language, Store Procedure, and SQL

Operating System: Window Server 2012/2008/2003.

ETL Tool: SSIS, Import Export Wizard, DTS (Data Transformation Services) BCP.

PROFESSIONAL EXPERIENCE

Confidential, Washington

SQL Server DBA

Responsibilities:

• Responsible for installation and configuration of SQL server 2005, 2008 RN, 2012.
• Provided support in a SQL Server 2012, 2008 Rn, 2005 clustered environment with 45 Server (20 Prod Server) and databases as large as 400 GB.
• Apply patches and service packs to keep the database at current patch level.
• Suggested disk capacity, processor, and memory based in the capacity planning.
• Upgrade the MS SQL server from 7.0 to MS SQL server to 2012.
• Based on business need implemented all the replication models.
• Maintaining of database size and disk space in production, staging and development environment.
• Solve critical production problem and perform point in time recovery plan.
• Creating database and database objects like table, store procedure, views, triggers, indexes, and function.
• Experience in resolving deadlock and blocking issue of concurrent user.
• Database migration and upgrade on the entire SQL Server version from SQL Server 2000 to SQL Server 2012.
• Migrating SSIS packages from SQL server 2005, 2008Rn to SQL Server 2012.
• Maintaining of database size and disk space in production, staging and development environment.
• Performing backups and restores using Transact-SQL statements and Red gate for SQL Server (third party tool).
• Resolving SQL Server agent job(s) failures, analyzing blocking and deadlocking issues, and proposing solutions.
• Granting necessary SQL Server permissions (security) in all environments.
• Monitoring system performance, for key servers, using performance counters.

Environment: Windows Server 2012/window server 2008Rn,TSQL, Spotlight, Red Gate, SQL Server 2012/2008Rn/2005,SQL Server management studio, Litespeed for SQL Server, SQL Server service manager, SQL Server agent, SQL Server replication services.

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Setup administration maintenance of SQL Server assessment, setup monitoring and troubleshooting of routine maintenance jobs and processes.
• SQL Server upgrade and migration for 2005 to SQL Server 2008Rn and SQL Server 2012.
• Setup of log shipping, mirroring, replication, always on, DR planning and performance improvement.
• Implementation of SQL Server operational automation for backup/restore, audit, and related maintenance.
• Setup of jobs and alerts for backup/restore (vldb) re indexing, integrity checks, database shrinking, T log growth monitoring and routine maintenance.
• Performed SQL server installation and configuration for SQL Server 2008rn and 2005.
• Perform installation of SQL Server service packs during maintenance weekend.
• Schedule full and transactional log backup for the user created and system database in the production environment using the database maintenance wizards.
• Streamline the server /database level security by creating the windows and SQL logins with the appropriate server/db roles and object level permissions.
• Used system monitor to find the bottlenecks in CPU, Disk I/0 and memory devices and improved the database server performance.
• Setup backup and restoration jobs for Prod, test, QA.
• Fine tuned store procedure using execution plan in T SQL for better performance.

Environment: SQL Server 2008Rn, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profile, SSIS, Spotlight.

Confidential, IL

SQL Server DBA

Responsibilities:

• Responsible for installing, configuring, performance tuning and monitoring SQL Server 2000/2005/2008 with over 100 SQL Servers and more than 75+ databases with large sized 500GB-1TB databases.
• Performed installations of SQL Server Enterprise 2005 64-bit version on Windows 2003 servers of clustered and standalone HP servers in enterprise Data Centers.
• Managed the production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning, SQL Server clustering, database security configuration.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like Management Studio, automated DB Maintenance plans, SQL Server Profiler, SQL Agents to setup alerts and scheduling of jobs.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as created stored procedures used in SSIS to load/transform data to the database.

Confidential

SQL Server DBA

Responsibilities:

• Served as a database administrator for installation, configuration, replication, tuning of Microsoft SQL Server 2000 servers in 24x7 production support project.
• Monitor and troubleshoot databases and servers for resource utilization and performance.
• Implemented data migration strategies for MS SQL Server 2000 and performed cleanup tasks.
• Developed overall SQL security strategy/architecture and Enforced database development and design standards to ensure that the code and designs are optimized for performance, security and ease of maintenance.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Provided index-tuning recommendations based on real time analysis of database performance metrics.
• Created alerts for monitoring purposes.
• Scheduled and monitored all maintenance activities of SQL Server, including checks on database consistency, index de-fragmentation and update statistics.
• Created SQL Maintenance Plans for production servers (Full, Differential and Transactional Backups) .
• Created Linked servers for retrieving data from other Servers including Oracle.
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.

Confidential, New Jersey

SQL Server DBA

Responsibilities:

• Extracted and transformed data using SSIS.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Wrote queries, store procedure in SQL Server.
• Worked on SSIS Package, Import/Export for transferring data between SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Participated in migration from SQL server 2000 to SQL server 2005.
• Handled large volumes of Data Warehouse database. Designing and loading the data into data warehouse (ETL).
• Used VBScript in ActiveX for DTS and SSIS packages.
• Expert in extracting and transforming data using DTS/SSIS Import Export Data, DTS/SSIS Packages, Bulk Insert and BCP.
• MS SQL Server 2000/2005/2008 backend programming of stored procedures and queries.
• Daily support, troubleshooting and, monitoring, optimization tuning of server and SQL server environments across entire system, query tuning.
• Involved in Migration from heterogeneous sources including Oracle to MS SQL Server.
• Created new tables, written stored procedures for application Developers and some user defined functions.