SUMMARY

• 10+ years of experience in Information Technology with a strong background in SQL Server Data Base administration.
• Administering SQL Server versions 2000, 20005, 2008, 2008R2 and 2012, 2016 and 2017
• Strong knowledge in configuring SQL Server replication and providing support for mission critical database recovery.
• Extensively worked on migrating SQL servers to Azure/AWS platforms
• Extensively worked with clients on implementing SAAS, PAAS and IAAS technologies
• Part of a 9 member DBA team managing around 4000 instances of sql server across the United States.
• Expertise in setting up new users and setting the roles for the users in SQL Server Administration console and currently maintaining multiple applications and large number of users.
• Expertise in SQL Server BI solutions for importing data into large Data warehouses and exposure to SSIS/SSRS
• Expertise in creating environment specific automated packages for installing SQL Server in Development, Test and Production servers
• Expertise in performing performance tuning SQL queries using query optimizer, installing indexes etc.
• Expertise in Starting and Stopping SQL Server services as per the predefined standards.
• Expertise in SQL Server database Migrations/deployments.
• Expertise creating TDP backup jobs which backs up data to Tivoli Data Protector..
• Excellent team player with an ability to perform individually, good interpersonal and analytical skills
• Good experience in documenting and doing best practices as per IEEE Standards.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server and Teradata.
• Experience in SQL Server multi node cluster installation.
• Expertise in handling mission critical database.
• Good experience working with Change requests (CR), Work orders (WO) and handling ticket queue for PROD issues.
• Thorough understanding of ITIL processes like Change, Release and Incident management.

TECHNICAL SKILLS

Expertise working with Tools: SQL Server client tools to connect to all Development, Test and Production to fix most of the issues, SQLServer Business Intelligence, Data Modeling

Databases: MS SQL 2000, 2005, 2008, 2008R2 and 2012

Languages: SQL, Shell Scripting

Other Tools: HPOV, CA Service Desk, ERWIN Data Modeler

Operating Systems: Windows NT Servers Windows XP

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA Tech Lead

Responsibilities:

• Worked extensively on implementing SAAS, PAAS and IAAS, Azure/AWS technologies
• Migrated almost 100 servers to Azure cloud platform
• Provided 24X7 support as a SQL DB Admin and point of contact for all administrative and performance tuning issues
• Worked closely with the end users in writing the functional specifications based on the business needs.
• Code migration from DEV - TEST and TEST to PROD by creating deployment codes
• Deployment of Sql scripts from DB DEV - TEST and TEST - PROD servers.
• Worked extensively on all SQL Server issues and database issues.
• Worked on SQLCMD commands and did the changes if required globally.
• Administered SQL Server, maintained database security.

Confidential

SQL DBA Manager

Responsibilities:

• Worked extensively on implementing SAAS, PAAS and IAAS, Azure/AWS technologies
• Migrated almost 100 servers to Azure cloud platform
• Provided 24X7 support as a SQL DB Admin and point of contact for all administrative and performance tuning issues
• Worked closely with the end users in writing the functional specifications based on the business needs.
• Code migration from DEV- TEST and TEST to PROD by creating deployment codes
• Deployment of Sql scripts from DB DEV - TEST and TEST - PROD servers.
• Worked extensively on all SQL Server issues and database issues.
• Worked on SQLCMD commands and did the changes if required globally.
• Administered SQL Server, maintained database security.

Confidential

Senior SQL DBA

Responsibilities:

• Provided 24X7 support as a SQL DB Admin and point of contact for all administrative and performance tuning issues
• Administered SQL Server, maintained database security.
• Created folders, permissions, setting up environments, versioning control,and creating new users for individual developers.
• Designed migration templates, process flow diagrams, process standards document and standard documentation for specifications of DB as per IEEE Standards.
• Performed SQL Server upgradation from SQL R2, 2016, 2017 etc..
• Troubleshooting SQL Server performance, workflow and connection issues.
• Creating User(s) / Group(s) in SQL Server
• Assigning the privileges to groups or for the particular user.
• Managing users existence (Changing password, Enabling/disabling user ids)
• Performing the startup/shutdown the SQL Server according to Company policy.
• Migrating the workflows from one environment to other environments.

Confidential

Data Modeler

Responsibilities:

• Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
• Worked closely with the end users in writing the functional specifications based on the business needs.
• Code migration from DEV- TEST and TEST to PROD by creating deployment codes.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Extensive Experience working with business users/SMEs as well as senior management.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
• Solid understanding of relational data model design, dimensional modeling & data warehousing methodologies

Confidential, Boise Idaho

SQL Server Database Admin

Responsibilities:

• Provided 24X7 support as a SQL DB Admin and point of contact for all administrative and performance tuning issues
• Worked closely with the end users in writing the functional specifications based on the business needs.
• Code migration from DEV- TEST and TEST to PROD by creating deployment codes and also XML Import - Export method.
• Deployment of Sql scripts from DB DEV - TEST and TEST - PROD servers.
• Worked extensively on all SQL Server issues and database issues.
• Worked on SQLCMD commands and did the changes if required globally.
• Administered SQL Server, maintained database security.
• Created folders, permissions, setting up environments, versioning control,and creating new users for individual developers.
• Designed migration templates, process flow diagrams, process standards document and standard documentation for specifications of DB as per IEEE Standards.
• Performed SQL Server upgradation from SQL R2 etc..
• Troubleshooting SQL Server performance, workflow and connection issues.
• Creating User(s) / Group(s) in SQL Server.
• Assigning the privileges to groups or for the particular user.
• Managing users existence (Changing password, Enabling/disabling user ids)
• Performing the startup/shutdown the SQL Server according to Company policy.
• Migrating the workflows from one environment to other environments.
• Clearing the active sessions of the user.
• Killing a process in SQL server.
• Changing the database owner of a database.
• Creating ODBC connectivity and troubleshoot the same.
• Automation of installing SQL Server Service Packs.
• Solving the SQL Server database connections issues.
• Clearing the huge size job logs.
• Create a new project/ assigning security groups for that project.
• Administered very large DBs
• Troubleshooting issues with SQL Server replication.
• Adding new tables for replication.
• User administration and security of users.
• Currently working on creating packages for SQL installation.
• Recovery of database during crash.
• Ensuring data consistency in database through DBCC commands.
• Experience in allocating system storage and planning future storage requirements.