SUMMARY

• More than 5 years of SQL database administration experience working on those aspects of database, such as Data Base Monitoring, Installation, Configuration, Mirroring, Disaster prevention and Recovery.
• Experience in RDBMS, database design, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012/2014.
• Expertise in Creating and maintain Databases, Tables, views, functions, stored procedures and other database objects and created various scripts using T - SQL, and Oracle SQL. familiarity with the main data manipulation languages and the principles of database design;
• In-depth understanding of security and backup procedures to ensure database integrity.
• Expertise in Reviewand optimizeprocedures, indexes, codes and table trending data flow.
• Experience in Database administration activities for DB Security, (creating logins, users, roles, and assigning permission to them)
• Strong experience in configuring and maintaining Mirroring Technology and fail-over.
• Experience in Disaster Recovery Planning, Execution and Security Management operations
• Excellent experience working on Microsoft office tools.Active cross-functional team player, result-oriented, fast learner, detail oriented.
• Expertise in Providing 24x7 technical database support for SQL Database systems.
• Good interpersonal skills, committed team player with team driven skills.
• Excellent communication skills with strong research capability.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R2/2005/2000, MS Access 2007 & 2003

Operating System: Windows Server 2012, 2008 R2/2003/2000

Language: SQL, T-SQL, HTML, DHTM, XML, java script, ASP, ASP.net

Applications: SQL-Loader, SQL Navigator Domain, Dreamweaver, wireshark

Reporting Tool: SSRS (SQL Server Reporting Services)

Networking: Active Directory, TCP/IP, DHCP/DNS, LAN

PROFESSIONAL EXPERIENCE

Confidential

SQL Database Administrator/DBA

Responsibilities:

• Created and maintained various databases on Production and development environments using SQL Server 2012/2008/2005/2000
• Write complex code, test and implement solutions using SQL Server 2008R2 and 2012
• Design, develop and support alldatabase objects required for reporting.
• Design, develop and code various T-SQL queries, stored procedures and functions to support front-end applications.
• Communicated regularly with technical, applications and operational staff to ensure database integrity and security;
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Used quires and sub-queries for complex business involving multiple tables & calculations from different databases.
• Migrated databases and creating test database for different applications.
• Controlled access permissions and privileges;
• Updated existing databases develop, managing and testing back-up and recovery plans
• Work Confidential regular hours based on business demands.
• Provided 24x7 on call technical database support for SQL Database systems.

Confidential, Vienna, VA

Database Administrator/DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2012 and 2008 R2 employed in development, test and production environment
• Designed alerts and notification when a DB is under pressure and when there is blocks and other issues arise that cause the queries to slow down.
• Administered production and development running on MS SQL Server 2014/2012, MS SQL Server 2008 R2 and MS SQL Server 2005
• Design, develop, and implement automated data backup and restoration procedures.
• Created Indexes to improve the performance as per Dev/App team request.
• Rebuild the indexes at regular intervals for better performance.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Upgraded Databases from SQL Server /2008 R2, from SQL Server 2005 to SQL Server 2008 R2/ 2012
• Created database triggers to implement business requirementsensuring data integrity is maintained at all timeswith the use of Data Manipulation Language (DML) and Date Definition Language (DDL)
• Implemented SQL Logins, Roles and Authentication modes as a part of Security Policies for various categories of User Support
• Managed database security.
• Monitored and took action when a database run in to memory issues.
• Work in disaster recovery and Operational Support team/production level issues.

Confidential

Database Administrator/DBA

Responsibilities:

• Installed, Configured, Monitored and troubleshoot SQL Server 2008, 2012 and 2014
• Installed SQL Server and its service packs, and also client installations as required
• Created logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions
• Involved in planning, design, analysis, implementation and maintenance of SQLserver databases.
• Test new database and data handling systems
• Developedrelational databases, writing queries, stored procedures, views, user-defines functions, etc.
• Established the needs of users and monitoring user access and security; monitoring performance and managing parameters to provide fast responses to front-end users;
• Implemented and tested the point in time recovery of the production databases
• Aware of potential blocking, deadlocking and other day to day routines and design to avoid those situations.
• Took backupand restore when needed.
• Create login/role on a necessary level permission for diverse groups and resolve any issue related to security working closely with project managers, programmers andother IT professional for the accessibility, security and consistency of the database