SUMMARY

• 7+ years of experience as Sr. SQL Database Administrator on Windows 2000/2003/2010/2016.
• Experienced in T - SQL Programming,Powershell scripting and Data Integrity, Performance Tuning, Query Optimization.Facets experience .
• Expertise in configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
• SQL DBA activities including Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases
• Expertise in Troubleshooting, Installation, configuration, Backup /recovery, database security, Data Transformation Services (DTS), Database design, query optimization, Security administration, Replication, mirroring, log shipping and clustering.
• Supported over 200 SQL servers, 2005/ 2012/ 2014/2016/2017 /2019 servers and 500+ databases in clustering environment (A/A, A/P) and databases 500+ Gig in size Import and export data (Dev to QA, QA to Prod).
• Set up and schedule jobs that perform backups and database structure checks. Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
• Technical Lead in charge of migrating over 180 databases from SQL Server 7.0 to SQL Server 2000 and SQL 2000 to SQL 2005.Experence with Active Directory, MSWC, hyper V, IIS, V sphere and Window server 2008, 2012, 2012 R2, 2016.
• Implemented a recovery plan to a point in time failure.Responsible for data security and Integrity.
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS,SSRS,SSAS, Log shipping, Database Mirroring, SQL Mail, database mail
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments.
• Azure storage. Administration of Azure sync, users, and groups. Performs health monitoring.Azure Active directory, Azure storage explorer for upload and download from and to local premises database and azure database. Export import to and from blob storage and azure database.export import from SSMS to local premises (SAN) and vice versa. Azure database to Geo replica in different azure datacenter making primary and secondary database and its failover. Creating azure AD users groups and implementing role in granular level.Hub to member database sync.
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Expertise in Troubleshooting, Installation, configuration, Backup /recovery, database security, Data Transformation Services (DTS), Database design, query optimization, Security administration, Replication, mirroring, log shipping and clustering.
• Experience in disaster recovery, performance tuning, and migration from 2000 to 2005 and 2008 to following new sql server version.
• Experience in installing multiple instances of SQL failover cluster on SQL 2005,2008,2014, 2016,2017 & 2019.
• SQL server profiler-used to generate workloads and test performance of databases and used the SQL server profiler to gather workloads over at least a 24-hour period.DATA GOVERNER, Degree of parallelism.
• Implemented different types of Replication models: Snapshot, Merge and Transactional, peer to peer.
• Experience with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS.
• Fluent in SQL Commands for resolving locks, deadlocks and blocking issues.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• As part of a team, analyzed the business requirements and systematically designed a database. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using SSIS.
• Configured SMTP SERVER for Database Mail setup and received Alerts for the Threshold values.
• Experience with JavaScript, HTML4/5, XHTML, DHTML, XML, XSLT and CSS2/3 Technologies.
• Extensive programming experience in writing web application programs covering front-end / JavaScript, jQuery and AJAX for building rich user friendly, high performance web applications.
• Deep understanding of Object-Oriented JavaScript programming and JavaScript MVC framework.

TECHNICAL SKILLS

Database: Microsoft Access, SQL Server, 2005, 2008, 2017,2019

Web Servers: IIS 4.0/5.0, 6.0, WebServices

Network Services: TCP/IP, DNS, HTTP, SMTP, DHCP, Load Balancers

O.S.: Windows NT/Windows 2000/2003/2008

Applications: Active Directory, MSWC, hyper V, IIS, V sphere.

Tools: DB Artisan 8.x, Quest (Lite Speed, SQL Watch), IDERA (SQL Safe, SQL compliance manager)

Languages: Transact-SQL, ASP, VB/JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Seattle WA

Sr Database Engineer

Responsibilities:

• Worked in a Data warehouse Environment. SQL Performance Tuning on long running queries. worked in developer, preprod and production environment on DBA and sql server related issues.
• Mirroring, log shipping, always on and DR experience and server performance and optimization. worked in Azure Iaas . mostly worked on developer side and written a lot of queries, plans, jobs and stored procedures.Azure IoT and Azure storage. Powershell scripting
• Supported over 50 SQL 2008/2016/2017 databases in 3 node clustering environment (A/P A/A) including database mirroring on critical databases and databases 40+ Gig in size
• Successfully Upgraded SQL 2008 to SQL 2016 and SQL 2016 to SQL 2017
• Designed, implemented, configured SQL 2008 dev/preprod environment on 2 node A/P cluster environment.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy on SQL 2005,2008,2012, 2014, 2016,2017 & 2019.
• Monitor database systems performance, capacity and availability.
• Work on data mapping and conversion; manage disk space, change control and bug fixes.
• Developed and implemented Disaster Recovery (DR) on production SQL Server .
• Manage and resolve trouble tickets (azuredevops ) for database-related issues submitted by customers
• DBA for SQL Server serving over 84 databases. Responsibilities include daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member with other DBA\'s to ensure 24 hour x 7 day a week support of all corporate databases. Involved in installing, configuration and administration of failover clustering
• Provide support to application developers in designing and implementing physical database structures.
• Wrote stored procedure to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Determined hardware and software requirements for SQL Server version 2017 and 2019. Tested the Installation of SQL 2017 Server.
• Contributed to implementation of HA/DR solutions for database servers of SQL 2012/ 2014/2016/2017 , including Failover Clusters, mirroring and Always On Availability Groups.
• Configuring Replication from Production to Reporting server and adding articles as and when new tables are created.
• Reconfigure the default locations of the data files; log files and error log files onto the SAN environment for all the servers.

Confidential, Broomfield CO

Sr. SQL Server DBA

Responsibilities:

• Responsible for provide 24 X 7 critical production support to all 100 Production, development and clustered servers.
• Supported over 90 pulse SQL 2000/ 2014/2016/2017 databases in 5 node clustering environment .
• Successfully Upgraded SQL 2016 to SQL 2017 and SQL 2017 to SQL 2019 and worked in SQL version Server 2005,2008,2012, 2014, 2016,2017 & 2019.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.Powershell scripting .
• Created snapshot of mirror database for reporting, Always On Availability Groups. Configured and maintain transactional, snapshot, merge replications.
• Designed and deployed SSIS packages in production environment to implement business logics.
• Installed SQL Server 2017 in clustered configuration. Planned, configured, tested and implemented failover cluster on Windows 2016.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2016 to MSSQL 2017.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2016 & 2017.
• Created DDL triggers for auditing any DDL change in SQL 2016.
• Implemented data Table partitioning to improve the performance of large table, reduces contention and increases availability of data
• Installed, configured and maintained Log shipping to create Standby Server.
• Created maintenance plan for database consistency and optimization.
• Involved in Change Management, Problem management activities using Service Now tool before implementing database changes in production and development activities.
• Created the backup and restore strategy for production, development and test environments.Involved in Disaster recovery and created the documentation.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.

Environment: Windows 2012 12R2/2016, SQL 2014/2016/2017 , T-SQL, Replication, SSIS, SSRS, Database mirroring, MS clustering, Lite Speed

Confidential, Woonsocket RI

Sr. SQL Server DBA

Responsibilities:

• Responsible for providing 24 hour critical production support to 20+ Production, development and clustered servers.
• Implemented and maintained high availability systems (clustering, database mirroring, log shipping)
• Successfully migrated SQL 2012 databases to SQL 2014,Powershell scripting
• Upgraded databases and database objects, including logins, stored procedures, and jobs.
• Create, deploy, configure and monitor complex ETL/SSIS packages Wrote stored procedure.
• Automated daily backup/restore processes, implemented batch jobs to automate DBA maintenance tasks.
• SQL Server clustering,optimization and performance tuning.
• Create and manage database maintenance plans and design and implement backup and disaster recovery plans.Define and enforce database standards, policies, security and documentation.
• Prepare current database structure and configuration for high-performance through analysis and optimization.
• Implementation of Database mirroring and transactional replication.
• Diagnose problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues.
• Monitor database systems performance, capacity and availability.
• Work on data mapping and conversion; manage disk space, change control and bug fixes.
• Developed and implemented Disaster Recovery (DR) on production SQL Server 2005

Environment: Windows 2012/2016, SQL server / 2000/2005/2008/2012 , T-SQL, Replication, Log shipping, failover clustering, Lite Speed, T-SQL, Replication, Log shipping, failover clustering.

Confidential, Denver CO

Sr. SQL Server DBA

Responsibilities:

• DBA for SQL Server serving over 80+ databases Responsibilities include daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member with other DBA to ensure 24-hour x 7 day a week support of all corporate databases.
• Involved in installing, configuration and administration of failover clustering
• Provide support to application developers in designing and implementing physical database structures.
• Wrote stored procedure to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization,Powershell scripting.
• Migrating over 180 databases from SQL Server 2012 to SQL Server 2014. Designed DR database backup and restore plan. SQL Server performance statistics collection, Server monitoring and performance tuning.
• User account management and connection troubleshooting. Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Implement and maintain database security, replication, SQL Clustering, stand by server, DTS, Log shipping.
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes. Implemented data models, database designs, data access
• Import and export data (Dev to QA, QA to Prod). Audit and generate monthly management reports using third party tool
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security). Formulated and monitored policies, procedures, and standards relating to database management.
• Provided project leadership within a functional database area of specialization.

Confidential

SQL Developer/DBA

Responsibilities:

• Developed presentation layer using JavaScript, jQuery, AJAX, HTML and CSS.
• Extensive use of Bootstrap.Implementing advanced JavaScript/CSS with Bootstrap to create interfaces and help manage cross browser compatibility.
• SQL Profiler and system Monitor. T-SQL .Participated in developing the online transaction system.backup restore, creating logins user and granting permissions.
• Developed Login/Registration/Edit of user profile integration with community sites using HTML5, CSS3, jQuery AJAX, JSON and JavaScript. front-end / JavaScript, jQuery and AJAX / PHP / CSS3/ HTML5. schedule jobs that perform backups and database structure checks. Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
• Implemented JavaScript for Form Validation, look and fell and maintaining consistency.
• Building database systems of high availability and quality depending on each end user’s specialized role.
• Designing and implementing databases in accordance to end user’s information needs and views.
• Administered MS SQL Server by creating user logins with appropriate roles, dropping the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups .

Technologies: SQL Server 2008, 2012