SUMMARY

• Over Eleven Years of working experience inSQL ServerasDatabase AdministratorinIT, Banking & Finance, Commercial,ecommerceenvironments.
• Having good experience in SQL server Architecture & Implementation. SQL Server Administration
• Experience on installing, configuring, managing, monitoring and troubleshooting SQL server.
• Experience in creating databases based on functional requirements and system design.
• Developing the successful Backup strategies based on Recovery models.
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Monitoring Database performance and optimizing performance.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Implementation of Database maintenance plan.
• Implementation of effective Indexing methods in order to boost the performance.
• Hands on experience in fine - tuning queries and stored procedures and troubleshooting performance issues.
• Implementation of Log Shipping, Replication.
• Creating and maintain SSIS, SSRS and SSAS packages
• Development of SSRS, SSIS, SSAS, MDS, MQS for all lines of business
• Maintenance of Data Warehouse
• Experience On-Call duties as assigned on a rotational basis.
• Experience in Performance Tuning and Optimization (PTO).
• Creating and maintaining Always On availability groups (HADR/ Replica).
• Experience on indexes, index management, and statistics.
• Knowledge on Relational databases, oracle, Sybase.
• Experience in supporting SQL Server production database instances.
• Experience withBusiness IntelligenceConcepts likeData ReportingandData Analysis.
• Performance Monitor for maintaining performance.
• Experience in using SQL monitoring tools like Spotlight, Idera.
• Experience in using Tivoli Storage Manager (TSM) for backups.
• Experience in working with Change Data Capture of SQL server 2012 and Resource Governor.
• Experience in PowerShell Scripting.
• Possess good technical and process documentation skills.
• Experience in schema designing and data modeling tools.
• Experience In cloud Technologies AWS (Amazon Web Services), Microsoft Azure.

TECHNICAL SKILLS

• SQL Server 2000/2005/2008/2008 R2/2012
• SSRS
• SSIS
• SSAS
• Planning and Creating Database Maintenance Plans.
• Backup storage planning Database Design and Implementation.
• SQL Clustering.
• Log Shipping.
• Database Mirroring and Replication.
• Always on high availability configuration.
• Data Transformation and Loading through SSIS.
• OLAP Administration via Microsoft SQL Server Analysis Services.
• Fine Tuning and Monitoring SQL Server.
• SQL Server capacity planning.
• Server and Database Security Administration.
• PowerShell Scripting.
• Monitoring tools used were spotlight
• Idera etc.
• Cloud Technologies AWS (Amazon Web Services)
• Microsoft Azure

PROFESSIONAL EXPERIENCE

Confidential - WEBSTER, NY

Database Specialist

Responsibilities:

• Involved in Building 3rd Datacenter for Confidential In Omaha, Out Of Region.
• Involved in installation and configuration of SQL Server, 2008R2,2012,2014.
• Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Worked on Projects to provide DBA support for Building SQL Servers for new applications (begin to end support).
• Migrating Databases from SQL Server 2008 to SQL Server 2012, 2014.
• Monitoring tools used Idera, SCOM .
• Implementing Backup and recovery plans for bigger databases of 1TB size.
• Implemented Always on High availability and Disaster recovery on all migrated instances.
• Resolving SQL Clustering (FCI) Failures.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Involved in planning Disaster recovery solutions.
• Development of a data strategy and associated polices.
• Selection of capabilities and systems to meet business information needs.
• Managing 2000 plus databases at the headquarters running on 250 servers.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Developed SQL scripts for maintaining administration tasks.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Created DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Controlling SQL Server Locking and finding and removing Deadlocks.
• Extensively used TSM lite speed backups.
• Troubleshooting Log shipping issues and Jobs.
• Ensuring high availability of the database exploiting the concepts of Mirroring, Replication, log shipping and clustering.
• Creating and maintaining SSIS, SSRS and SSAS packages.
• Development of SSRS, SSIS, SSAS, MDS, MQS for all lines of business.
• Maintenance of Data Warehouse.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Resolving alerts raised by the monitoring tool spotlight.
• Writing/DebuggingSQL Queries.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Good experience in data modeling and metadata services.
• Implementing Organization Cloud Engineering Strategies in various environments.
• AWS (Amazon Web Services) EC2, Cloud watch.
• Utilized Cloud watch to monitor EC2, CPU Memory, Amazon RDS DB services.

Environment: SQL Server 2016, SQL Server 2014, SQL Server 2012, sql server 2008R2, SQL Server 2005, Win 2008 Server, Win 2012 Server, SQL Server Database projects applied across through environments version control process, The application is being written in web technologies usingASP.NETMVC 5, C#, and SQL with a MS-SQL backend database.

Confidential - New york

Database Specialist

Responsibilities:

• Involved in installation and configuration of SQL server 2000,2005,2008R2,2012.
• Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Worked on Projects to provide DBA support for Building SQL Servers for new applications (begin to end support).
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Implementing Backup and recovery plans for bigger databases of 1TB size.
• Implemented Always on High availability and Disaster recovery on all migrated instances.
• Resolving SQL Clustering (FCI) Failures.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Involved in planning Disaster recovery solutions.
• Development of a data strategy and associated polices.
• Selection of capabilities and systems to meet business information needs.
• Managing 2000 plus databases at the headquarters running on 250 servers.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Developed SQL scripts for maintaining administration tasks.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Created DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Controlling SQL Server Locking and finding and removing Deadlocks.
• Extensively used TSM lite speed backups.
• Troubleshooting Log shipping issues and Jobs.
• Ensuring high availability of the database exploiting the concepts of Mirroring, Replication, log shipping and clustering.
• Creating and maintaining SSIS, SSRS and SSAS packages.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Resolving alerts raised by the monitoring tool spotlight.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Good experience in data modeling and metadata services.

Environment: SQL Server 2012, sql server 2008R2, SQL Server 2005, Win 2008 Server SQL Server Database projects applied across through environments version control process, The application is being written in web technologies usingASP.NETMVC 5, C#, and SQL with a MS-SQL backend database.

Confidential

Senior Database Administrator

RESPONSIBILITIES:

• Involved in installation and configuration of SQL server 2000,2005,2008.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Worked on Projects to provide DBA support for Building SQL Servers for new applications (begin to end support)
• Managing 500 plus databases at the headquarters running on 107 servers
• Developed SQL scripts for maintaining administration tasks.
• Created DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.
• Health checking the Production servers.
• SQL server Architecture & Implementation. SQL Server Administration
• Creating and maintain SSIS, SSRS and SSAS packages
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Controlling SQL Server Locking and finding and removing Deadlocks
• Recover databases in case of any crashes.
• Troubleshooting Log shipping issues and Jobs.
• Ensuring high availability of the database exploiting the concepts of Mirroring, Replication, log shipping and clustering.

Environment: Sql server 2008R2, SQL Server 2005, Win 2008 Server.

Confidential - California

Senior Database Administrator

Responsibilities:

• Installation, configuration and upgrading of Microsoft SQL Server 2000,2005.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Database tuning and performance monitoring.
• Application tuning and performance monitoring.
• SQL server Architecture & Implementation. SQL Server Administration
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7×24 supports when required.
• Do general technical trouble shooting and give consultation to development teams.
• Ensuring high availability of the database exploiting the concepts of Mirroring, Replication, log shipping and clustering.

Environment: Sql server 2008, SQL Server 2005, Win 2003 Server.

Confidential

Database Administrator

Responsibilities:

• SQL server Architecture & Implementation. SQL Server Administration
• Involved in configuring and converting MS SQL server 2000 database to MS SQL Server 2005
• Partially involved in Database design and Database objects.
• Created backups for databases.
• Partly Involved in Performance tuning
• Installing SQL server 2005 databases
• Health checking the Production servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Controlling SQL Server Locking and finding and removing Deadlocks
• Recover databases in case of any crashes.
• Creating and maintain SSIS, SSRS and SSAS packages
• Troubleshooting Log shipping issues and Jobs.
• Ensuring high availability of the database exploiting the concepts of Mirroring,Replication and log shipping.

Environment: SQL Server 2005, 2000, sql server 7, sql server6.5 .

Confidential

Database Administrator

Responsibilities:

• Involved in configuring and converting MS SQL server 7.0 database to MS SQL Server 2000
• Partially involved in Database design and Database objects.
• Created backups for databases.
• Partly Involved in Performance tuning
• Installing SQL server 2000 databases
• Health checking the Production servers.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Controlling SQL Server Locking and finding and removing Deadlocks
• Recover databases in case of any crashes.
• Troubleshooting Log shipping issues and Jobs.
• Ensuring high availability of the database exploiting the concepts of replication and log shipping.

Environment: SQL Server 2000, sql server 7, sql server6.5.