SUMMARY:

• MS SQL Server DBA with extensive knowledge in Managing SQL Server environment.
• Thirteen years of IT experience with 5+ as Database Administration in MS SQL SERVER 2012/ 2008 R2/ 2008/ 2005 in Production, Development, Testing Environments and 7+ as Software Developer, Team Lead and Project Manager.
• Hands - on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2012/ 2008 R2/ 2008/ 2005 on Windows 2012/2008 R 2/2008/2003/2000.
• Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).
• Experience with upgrading SQL Server, database migration from version 20 /2012.
• Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.
• Knowledge on Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
• Experience with server build and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's and SQL Query Analyzer and performed Query Optimization.
• Hands-on experience with SSIS (SQL server Integrated Services) and SSRS (SQL server Reporting Services).
• Experience in designing & implementing high availability, clustering and mirroring on standby, large database.
• Automated database consistency checks, Fragmentation checks and Index Reorganization/ Rebuilding operations.
• Experience in creating roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email notifications using SQL Server Agent.

TECHNICAL SKILLS:

Operating Systems: Windows 2012/2008 R2/2008/2003, Windows 7/8 Professional

RDBMS: SQL Server 2012/2008 R 2/2008/2005/2000 , MS Access

Database Tools: SQL Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS

Web Technologies: XML, HTML, JAVA Script

Languages: T-SQL, C, JAVA, .NET

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Applications: Microsoft Office, ERWin, MS Visio

Other Tools: Power Designer, SQL Nexus, PSSDiag

PROFESSIONAL EXPERIENCE:

Confidential - Milwaukee, WI

MS SQL Server DBA

Responsibilities:

• Provided 24/7 on call production support.
• Managed 250+ Production SQL Servers in Virtual and Physical Environments.
• Experience on installation, configuration and migration of SQL Server 2005, 2008 R2, 2012 on Windows 2012, 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Involved in development activities like database design, architecture and SQL scripting.
• Implemented Database Mirroring on SQL Server 2008 R2 environments.
• Experience with SQL Profiler and Query tuning Wizard to troubleshoot problems and queries.
• Working knowledge on HA and Always on clustering.
• Upgraded SQL Server 2005/2000 to SQL Server 2012/2008 R2.
• Managed multiple SQL Server instances in Active/Active and Active/Passive clusters.
• Installed and configured Async and Sync Mirroring for Production and DR environments.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle).
• Planned the complete Backing up of Database and restoring the Database from Disaster Recovery.
• Used extensive SQL Server DMV's for Performance and System Monitoring.
• Involved in migrating SQL Server Databases from Test Server to Development Server and from Development to Production Server.
• Creating, Scheduling and deploying SSIS packages from Development to Production.
• Used third Party tools for monitoring SQL Servers and Backing up Databases.
• Hands on experience with IBM Netezza (PureSystems) appliance and Linux, which is use for analytics purpose.
• Hands on experience with Powershell scripting to automate process.

Environment: Windows 2012/2008 R2 Server, MS SQL Server 2012/2008 R2/2005, T-SQL, Netbackup, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler, SQL Nexus, IBM Netezza (PureSystems), Powershell, Linux.

Confidential - Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.
• Worked on resolving major performance issues for databases.
• Researching on database/index fragmentation and running rebuild indexes and update statistics.
• Using latest SQL Server DMV’s for finding performance bottlenecks.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Configured the Log shipping and scheduled jobs to setup log shipping between production servers.
• Implemented Transactional Replication between Primary Server and Sub Systems.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Created Users and Roles, and managed security and permission of different SQL Server objects.
• Running DBCC consistency check and fixing data corruption in user databases.
• Experience in Tuning Databases using Performance Dashboard.
• Developed several reports using SQL server Reporting services (SSRS).
• Maintained stand by servers using log shipping and replication concepts.
• Prepared the coding guideline documents for SQL server developers.
• Extensively used SSIS to move data from text files to SQL Server.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.

Environment: Windows Server 2008 R2, Microsoft SQL Server 2012/ 2008/ 2005 , T-SQL, SSIS, SSRS, Database Tuning Advisor, SQL Profiler.

Confidential - Secaucus, NJ

SQL Server DBA

Responsibilities:

• Installation of SQL server 2005/2008 on Production and Virtual environments.
• Implemented transactional and snapshot replication in development environment.
• Used dynamic management views (DMV’s) to monitor the health of a server instance, diagnose problems, and tune performance.
• Interacting with Business Analysts & Developers in identifying the business requirements, designing and implementing the database schema.
• Installation of SQL servers on Development, Stage and Production Servers.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting privileges to users and groups.
• Provided 24/7 on call production support during off hours/ weekends/ holidays.
• Experience in using Crystal Reports for designing reports.
• Created batch files for executing the SQL server database objects.
• Imported data from text files and excel spread sheets into SQL Server 2000 databases using DTS packages.
• Writing new stored procedures and modifying existing ones and tune them such they perform well.
• Implemented auditing using triggers and enforcing business rules via checks and constraints.
• Automated processes using SQL Server jobs.
• Proper use of views to prevent unauthorized access.

Environment: Windows Server 2008/ 2003, MS SQL Server 2008/ 2005/ 2000 , SSIS, SSRS, SQL Compare.

Confidential - Camp Hill, PA

SQL Server DBA

Responsibilities:

• Provided 24/7 production support on a rotating roster schedule.
• Suggested design and architecture structure for Databases and servers.
• Implemented SQL Server 2012/2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
• Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
• Configured and Monitored MS SQL Server 2008R2 in Log Shipping from primary server to DR server (different geographical location) and also carried out role changes and role reversals.
• Installed and configured SQL Server 2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development & Production environments
• Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
• Used Performance Monitor and SQL Server Profiler (ran Trace) to optimize long running queries and thereby improved the performance of the queries.
• Worked with different teams (Application, Active directory, Engineering & QA) to deploy projects to UAT (Testing), Development, and Production environments.
• Used SQL Server Upgrade Advisor to analyze SQL server 2005 in the process of migration.
• Hands on experience with SQL development like stored procedure, function.
• Created packages successfully using SSIS to transfer large volume of Data.
• Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.

Environment: Windows Server 2008 R2/2003/2000, MS SQL Server 2012/ 2008 R, Business Intelligence Development Studio, T-SQL, SSMA, SQL Safe backup, IDEARA Diagnostic Manger, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler