SUMMARY

• 11+ years of experience in database administration of MS SQL 2012/2008R2/2008, Installation, Patching and Upgrading, Configuration and monitored appropriate disk storage.
• Expert in planning, implementing and performing daily tasks including back - up and restore, SQL Profiler, SQL Server Agent, and database engine tuning advisor.
• Manages and administers RDBMS platforms including MS SQL Server.
• Administering SQL server high availability, such as Mirroring, Log shipping, Cluster, Replication and Always on and disaster recovery strategies.
• Expertise and proficiency in MS SQL server performance tuning, query optimization, client server connectivity and database consistency checks using DBCC.
• Experience in maintenance plans to perform Indexes-de-fragmentation, re-organizing and rebuilding indexes, database cleaning and update statistics.
• Document development and production database environments
• Solid experience in creating jobs, alerts and scheduling.
• Expert in writing and using T-SQL.
• Hands on creating, managing and delivering server based reports using SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Extensively worked on DTS, BCP to import and export data from flat files, Excel and MS Access to MS SQL server databases.
• Expert in managing Multi-Terabyte (TB) Content Databases.
• Supports database functions by designing and coding utilities
• Optimize database resources by identifying potential resource bottlenecks and rectifying them.
• Support teh database needs of various development application support teams.
• Experienced in data partitioning and snapshot isolation.
• Develop scripts and processes to move data between databases.
• Experience developing automated maintenance processes.
• Expert in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Designs ETL solutions through analysis of business objectives and knowledge of available toolsets.
• Develops and maintains ETL processes to manage data from several internal/external systems.
• Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
• Assisted MS SQL developers to optimize SQL queries and stored procedures.
• Experience in working on tough schedule like 24/7 production database on call support.

TECHNICAL SKILLS

Server Operating Systems: Windows Server 2008/2008R2/2012.

DBMS: MSSQL Server 2008/2008R2/2012, MS Access.

ETL Tools: DTS, SSIS

Reporting Tools: SSRS

Programming Languages: T-SQL, HTML, XML, PowerShell.

Network Topologies: TCP/IP,FTP,SMTP.

Third Party Tools: Redgate, Idera, Spotlight.

Applications: IIS, Visual Studio, SharePoint.

Networking: SAN, NAS,LAN,WAN.

PROFESSIONAL EXPERIENCE

Confidential, Sterling VA

Database Administrator (DBA)

Responsibilities:

• MS SQL server 2012 Installation and configuration, patching and upgrading, both in standalone and cluster environment of production, testing and development.
• Automated maintenance plan jobs in SQL Server Agent and task schedule such as: back-up database, Index re- building, creating filtered Index, Index re-organizing, cleaning up data bases and update statistics.
• Involved in designing, developing and supporting custom database applications including working on developing stored procedures, conducting data modeling, database optimization, and going through teh process with developers to enhance and modify databases to satisfy new client requirements
• Configured and managed database Mirroring.
• Managed back-up/restore, point in time recovery.
• Extensively used SQL native tool like Index tuning wizard, Database Tuning, Advisor (DTA),SQL Profiler, performance Monitor, Activity Monitor, Dynamic Management View (DMV) and Dynamic Management Functions (DMF) for monitoring performance tuning/trouble shooting.
• Use DBCC for different database maintenance tasks.
• Extensively writing and using T-SQL.
• Analyze locks, deadlocks using both spotlight, DMV and DMF and handling teh isolation level and concurrency effects.
• Developed, implemented and administered policies and procedures for ensuring security and integrity.
• Auditing of database for users transaction login and removing orphan users.
• Moving a multi TB Database from one disk to another.
• Worked with Business Analyst (BA) managers, development leads and QA leads in deciding teh timeline for completion of BA in order to coincide with their schedule.
• Worked in Normalization, database design, performance analysis and production support.
• Manage defragmentation, recreating indexes on tables for performance improvements.
• Managed concurrency problems of blocks, locks, deadlocks using Activity Monitor Profiler
• Optimize database resources by identifying potential resource bottlenecks and rectifying them.
• Perform space management (tablespace and rollback segment), archiving, partitioning and compression techniques for performance and manageability
• Migrated data from various sources using SQL Server Integration Services (SSIS)
• Worked and generated reports using SQL server Reporting Services (SSRS)
• Creating SQL server logins, groups users and assigned roles and autantication mode as part of security policies for various categories of users support.
• 24 X 7 Production Database on Call, remote, and in person Support.

Confidential, Birmingham, AL

Database Administrator (DBA)

Responsibilities:

• Installed, configured, updated and managed MS SQL 2008R2/2008 in development, testing and production environment.
• Extensively worked on data modeling.
• Configured and managed log shipping as stand by database from production database.
• Proactively monitor as well as troubleshoot problems escalated by teh business / QA / Analytics / Development team in a timely manner.
• Writing SQL/T-SQL, triggers, stored procedures and working with developers in writing queries and debugging codes.
• Manage defragmentation, recreating indexes on tables for performance improvements.
• Developed, implemented and administered policies and procedures for ensuring security and integrity.
• Migrated database from SQL server R2 anfd2012.
• Scheduling and automating full, differential and transactional back-ups and implemented recovery strategies.
• Scheduling and automating maintenance plans using SQL Server Agent.
• Upgrading teh SQL server database, monitoring and performance tuning.
• Developed automated procedures to produce client data files and schedule using SQL Server Integration Services (SSIS).
• Developed reports using SQL Server Reporting Services, crystal reports with T-SQL, MS Access and MS Excel.
• Monitored Servers activity and solve problems.
• Creating and rebuilding Indexes for better performance.
• Checking teh database health regularly by using DBCC command and DMV.
• Monitored and modified performance using execution plans and Index tuning.
• Worked extensively in query analyzer and SQL profiler for tuning queries using variables for characteristics and query costs.
• Administer teh MS SQL Server by creating user logins with appropriate roles, drop and lock teh logins, monitor teh user accounts, creation of groups, give teh minimum(Grant, Revoke or deny) privileges to users and groups.
• Created and managed schema objects such as tables, views, indexes, store procedures, triggers. worked on 24/7 production database on call support.

Confidential, Newark, NJ

Junior Data Base Administrator (DBA)

Responsibilities:

• Installed, Configured, updated and managed SQL Server 2008R2/2008.
• Monitored database back-ups and other jobs in teh maintenance plan restoration and point-in-time recovery monitoring server activity, error log, space usage and solving problems as needed.
• Developed maintenance plan such as, back-ups, Index management, fragmentation management, cleaning history and update statistics.
• Documentation and automation various database related procedures.
• Set up database high availability environment, Log shipping and Replication.
• Re-building Indexes with different fill factor and update statistics manually.
• Monitored MS SQL Server performance,
• Troubleshoot performance problems and fine-tuning of databases
• Resolved issues related to query optimization, database optimization and Index tuning.
• Running SQL Profiler to troubleshoot blocking issues, deadlock issues and slow running queries.
• Database migration from R2, and 2012.

Confidential

Junior Data Base Administrator (DBA)

Responsibilities:

• Configured and managed 2008 R2/2008 MS SQL Server.
• Created database tables, views, and stored procedures.
• Performed full, differential and transactional back-up/restore.
• Configured and managed Mirroring.
• Developed maintenance plan for Index maintenance.
• Monitored MS SQL Server performance using SQL profiler to find blocks and dead locks.
• Analyzed, interpreted and report writing of many socio-economic, demographic, health and population Census (data) using SPSS packages.