SUMMARY

• Around 8 years of IT experience as SQL Server Database administrator, providing 24/7 support of both development and production databases.
• Hands - on working experience in Installing, configuring, upgrading and managing SQL Server 2008-R2/2012 and required Service Packs.
• Experienced in implementing efficient Disaster prevention and Recovery Strategies by creating backup and restore plans according to business RTO and RPO.
• Performed administrative activities like creating User logins with appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.
• Proficient in creating maintenance plan to automate backup jobs, check database integrity, reorganize and rebuild indexes.
• Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and created database mail using SQL Server database mail configuration.
• Configured and maintain Replication, Log shipping, database mirroring, Clustering (Active/Passive), Always-on.
• Setup and configure remote linked servers for remote and distributed queries.
• Experience in using Profiler, Activity Monitor, Execution Plans and Performance Monitor to resolve Deadlocks, long running queries and slow running databases and to identify root cause of the problem.
• Experienced in Online Indexing, Performance Tuning, DTA, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Good experience in Debugging Stored Procedures, triggers and Troubleshooting database issues.
• Experience handing Batch processes using BCP, SSIS packages, Import & Export wizard.
• Configured and deployed SSIS and SSRS packages from development to the production environment.
• Have exposure to Light Speed and Spotlight as a third-party backup and monitoring tool.
• Provide excellent support to both team members and clients on site or over the phone.
• Have excellent communications and interpersonal skills and can fit in any environment.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R 2/2008/2005/2000

Operating Systems: Windows Server 2008R2, 2008, 2003R2, 2003, Windows 2000 Server/ Advanced Server, Windows XP/7/8

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

Languages: T-SQL, SQL, XML

Reporting Tools: SQL Server Reporting Server 2008/2005, SSIS

Application Programs: SQL Diagnostic Manager, SQL Server Profiler, SSMS, Dreamweaver, Microsoft

Others: Power Shell, Data Modeling, Data Normalization, Relational Database Design Implementation, Log shipping, Mirroring, Replication, Query optimization and Performance tuning, Database backup and recovery, Database upgrade, Stored Procedure, functions and triggers, DTS, SSIS etc.

PROFESSIONAL EXPERIENCE

Confidential - Weston, FL

Microsoft SQL Server Database Administrator

Responsibilities:

• Experienced in migrating from MSSQL Server 2008 to MSSQLserver 2012 and Migrating database from Oracle 11gR2 to SQL server 2012
• Creating, developing and maintaining SQL Server Stored Procedures.
• Experience in Optimizing Code and Improving Efficiency in databases including Re indexing, Updating Statistics, Using SQL Profiler, Recompiling Stored Procedures and performing other maintenance tasks.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Created Triggers to enforce data and referential integrity.
• Experienced in Full backup, Differential backup and Transactional Log backup.
• Defined constraints, rules, indexes and views based on business requirements.
• Performed daily tasks such as backup and restore by using SQL Server Management Studio.
• Used Execution Plan,SQLProfiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created different SSIS Package using a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, conditional split, For Each Loop.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Migrated data from different sources (text based files, Excel spreadsheets CSV files, and Access) toSQLServer databases usingSQLServer Integration Services (SSIS).
• Expert in creating various type of reports such as drill down & drill through reports, Matrix reports, Sub reports and Pie Charts usingSQLServer Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing reports like reports using Cascading parameters, Parameterized Reports and Report Models usingSQLServer Reporting Services (SSRS) based on client requirement.
• Used expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Developed User Defined Functions and created Views.

Environment: SQLServer 2008/2012, Visual Studio 2010, Analysis and Reporting Services, Management Studio, Windows Server 2008, Smart Application, Access Database, MS office 2010, Share point 2010, Project Server 2010.

Confidential, Atlanta, GA

SQL Server Database Administrator

Responsibilities:

• Installed and Configured SQL Server 2005/2008 R2/2012 Servers in Development, Staging, and Production Environments.
• Created databases, logins, roles and granted appropriate permissions.
• Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Supported 24*7 production support and solved all kinds of critical problems.
• Participated in SDLC methodologies such as planning, analysis, design and implementation.
• Setup Log Shipping and Mirroring for day one critical database as a High Availability Solution.
• Setup Replication (both Transactional and Merge replication) for multiple point of presence for business data.
• Setup, implement, and maintain industry standards in database management.
• Created Database Maintenance Plan for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Imported and Exported data (Migrated) from different sources other than SQL server (such as Access, Flat files) using Import/Export wizard.
• Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Worked well with team members to bring the databases up to the business requirement.

Environment: T-SQL, SQL Server 2005/2008R2/2012, OLTP, TCP/IP, SSIS, ETL, Windows 2005, 2008, Redgate, Spotlight.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed SQL Server using standard check list.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Recovered databases in the event of a disaster by developing and maintaining relational structures including backup/recovery and log shipping procedures.
• Created and managed clustering environment such as active/passive clustering.
• Configured and managed log shipping and database mirroring.
• Monitoring the servers using Spotlight third party Quest software to detect CPU usages, performance issues, and disk performance.
• Using indexes, fine-tuned databases to perform query faster.
• Worked with DTA to improve performance of queries by implementing indexes to the missing tables.
• Created Triggers to enforce data and referential integrity.
• Work with Product Managers and a development team to implement integrated solutions with various technology platforms between internal technologies & outside vendors.
• Worked with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Experience with Project Management Methodologies like Agile, Water Fall.
• Supported 24/7 support to the team members and other clients on call during business and non-business hours.

Environment: SQL Server 2008 R2, Log Shipping, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, Spotlight.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Created, manipulated and supported theSQLServer databases.
• Migrated data between SQL Server 2005 to SQL Server 2008 using Copy Database Wizard or manually attached/detached.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with theSQLServer backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Imported & Exported of data from one server to other servers using tools like Data Transformation Services (DTS)
• Wrote T-SQLstatements for retrieval of data and involved in performance tuning ofT-SQLqueries.
• Created documentation as required.

Environment: SQLServer 2008, T-SQL,SQLServer Integration Services (SSIS),SQLServer Reporting Services (SSRS), Query Analyzer, MS-Excel, MS Access 2010,SQLprofiler,SQLServer Agent.