PROFESSIONAL SUMMARY:

• Experienced in application development from initial requirements gathering, systems design, specification, and documentation, deployment, and training.
• Experienced in installing, upgrading, patching, administration and maintaining Microsoft SQL Server database in Production, Development and test environments.
• Experience in installing and configuring SSIS, SSRS, and SSAS and applying service packs, patches, hotfixes and cumulative updates.
• Experience in implementing SQL Server security and object permission like maintaining creation of users, configuring permissions database authentication modes and assigning roles of users.
• Expertise in implementing different types of high availability and disaster recovery (HADR) mechanisms like replication models, backup/restore, log shipping, database mirroring, clustering and Always On availability groups.
• Ability to establish and maintain sound backup and recovery/restore policies and disaster recovery procedures to meet the business Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Having hands on experience migrating scripts in a production environment and extensive experience in stored procedures, triggers, cursors, views, tables and SQL joins to meet business requirements.
• Expertise in extracting and transforming data using data transformation services like import/export wizard, BCP, Bulk insert, attach/detach. Also proficient in migration /movement of data between databases
• Expertise in automating maintenance jobs in SQL Server job agent and task scheduler: such as shrinking database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, updating statistics and full, differential and transactional log backups and other SSIS package tasks.
• Experience in Data Extraction, Transforming and Loading (ETL) using SSIS.
• Experienced in Configuring, administering SQL Server Reporting Services (SSRS),Integration service (SSIS) and Analysis service(SSAS)
• Experience in Query Tuning by using SQL Profiler, Execution Plan, Trace Statistics, DBCCs, and DMV etc.
• Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance, implementing cutting - edge technology solutions, and training/supporting end users.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Platforms: Windows 2003/2008/2008 R2/2012 server

RDBMS: Microsoft SQL Server, 2012/2008/2005/2000, MS AccessSQL Server Tools: Enterprise Manager, Management Studio, Query Analyzer, SQL Profiler, DTS/SSIS (ETL), Database Tuning Advisor (DTA), and third party tools IDERA, Red Gate

Case Tools: MS Office 2000/XP/ 2003/2007/2010/2013, MS Excel 2000/XP/ 2003/2007/2010/2013, MS Outlook / 2000/2003/2010/2013, MS Visio

Programming Language: C#,VB.NET,ASP.NET,C++

BI and Modeling Tool: SSIS, SSRS, SSAS, Erwin

Storage & Networking: SAN, NAS, LAN, WAN.

PROFESSIONAL EXPERIENCE:

SQL DBA

Confidential

Responsibilities:

• Installation, upgrade, configuration, administration and Migration of Microsoft SQL Server (MSSQL 2008, 2008R2 and 2012) in clustered and no clustered in production environment.
• Assigned permissions to users and roles, administered secure authenticated logins and supported columns level permission and other security related issues including creation and granting permissions on various objects.
• Experienced at planning and performing full, differential and transactional Backups and restore job and recovery models.
• Auditing of database for user transactions, login and database action and in removing orphaned user.
• Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer, and Database Engine Tuning Advisor.
• Developed and documented backups, recovery strategies, disaster recovery mechanism and participated disaster recovery drills for various environments.
• Expertise in Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Scripting the database consistency checks (DBCC), scheduling the script to run daily and on weekly basis as required by the business and configure SQL Server monitoring utilities to minimize false alarms.
• Expertise in Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Responsible for data migration from Excel, Flat file, Oracle to Microsoft SQL Server by using BCP as well as Extracting, Transforming and Loading of data using Microsoft SQL Server Integration Services/SSIS.
• Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.
• Experienced in setting up and configuring Database Mail, notification and alerts.
• Experience in monitoring and troubleshooting database issues like Memory, CPU, I/O, Disk utilization, Blocking, Deadlock, fragmentation etc.
• Regularly checked database consistency and Monitored SQL Server activities/issues.
• Created SQL Server Agent jobs to automate different activities such as monitoring database health, disk space, job alert, index monitoring, stats monitoring.
• Extensive knowledge of security policies and procedures for securing SQL Server DBs
• Involved in Weekly Change Management meeting

Environment: SQL Server 2008, 2012 SQL, SSRS, Windows Enterprise Server 2012/2012R2/2008R2/2008, Microsoft Reporting Services.

SQL DBA

Confidential

Responsibilities:

• Administrated and managed the SQL Server 2008R2, 2012 production and Non-production servers.
• Configured and audited SQL Server security in line with business requirement, managed SQL Server logins, user account and passwords along with database object permissions
• Monitored, assessed reconfigured database storage spaces, capacity and estimated sizing and growth requirements in MS SQL Databases
• Experienced in creating SSIS packages using proper control and data flow elements.
• Export and import data from source like flat files, row files using DTS, SQL Server Integration Services.
• Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
• Migrated SQL Server 2005 databases to SQL Server 2008R2/2012 databases including DTS to SSIS packages.
• Implemented high availability on the various servers using Replication, Log-Shipping and Mirroring.
• Backing up and restoring the database manually and also by scheduling the jobs and maintenance plan as required.
• Implemented and tested the point in time recovery of the production databases.
• Experienced in implementing TDE on production databases.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Configured data partitioning and table partitioning on huge tables containing numerous numbers of rows for better performance.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Created necessary templates for various requirements gathering and documentation.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitored Log shipping and Transactional Replication and troubleshooting of errors.

Environment: SQL Server 2012, 2008 SQL, SSRS, Windows Enterprise Server 2012/2012R2/2008R2/2008, Microsoft Reporting Services.

SQL DBA

Confidential

Responsibilities:

• Installation and configuration of SQL Server 2000/2005 components, installing and configuring windows 2005 failover cluster for SQL Server 2000 and 2005.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high rating audits.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared folder.
• Designed and implemented comprehensive backup plan and disaster recovery strategies implemented and scheduled Replication process for updating our parallel servers.
• Rebuilding the indexes at regular intervals for better performance
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Maintaining the database consistency with DBCC at regular intervals.
• Good experience in data modeling and metadata services.
• Set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Performed installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of SQL Servers databases.

Environment: MS SQL Server 2008, MS SQL Server 2005, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), MS Excel, SQL Server Reporting Services (SSRS), Windows 2008/2003

SQL DBA

Confidential

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared DFD's & Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T-SQL Programming.
• Experienced in creating, setting and maintain Database Administration scripts.
• Worked Extensively in T-SQL for creating, altering and maintaining databases and database objects.
• Managing SQL Server databases access security privileges and permission for groups, roles users and logins, created and supported complex database schema and administration task of SQL Server.
• Experienced in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Tuning query by using SQL Profiler, Execution Plan, Trace Statistics, DBCCs, and DMV etc.
• Experienced in configuring, monitoring and troubleshooting solutions.
• Experienced in configuration of report server and report manager scheduling, give permission to different level of users in SQL Server Reporting Services.
• Experienced in using native tools such as Database Engine Tuning Advisor, Index Tuning Wizard, and Windows Performance Monitor for Monitoring and Tuning, SQL profiler for MS SQL Server Performance tools.

Environment: SQL Server 2005, MS-Access, Performance Monitor, Backup Utility, Windows 2003, SQL Profiler.

IT Instructor

Confidential

Responsibilities:

• Taught C++, Visual Basic, Database Management System, Web Page Authoring, Introduction to Computer and Digital Electronics, C#, JavaScript, Intermediate Networking and Microsoft Office Packages
• Preparation of students manual
• Advised Graduated student in Database Development, C#/VB.Net
• Worked in System Development Team
• Served as a course coordinator for four classes: C++, Web, Database, office Package