PROFESSIONAL SUMMARY:

• 8+ years of experience as Sr. SQL Database Administrator on Windows 2000/2003/2010.
• Experienced in T - SQL Programming and performance tuning, optimization.
• Worked on Data Integrity, Performance Tuning, Query Optimization.
• Expertise in configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
• SQL DBA activities include but not limited to 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 2000/2005 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
• Implemented a recovery plan to a point in time failure
• Responsible for data security and Integrity with HIPAA requirements
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL Mail, database mail
• Responsible for establishing best practices, standards. Responsible for establishing and enforcing security mechanism
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments
• 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 and 2008.
• Experience in installing multiple instances of SQL failover cluster on SQL 2005 & 2008.
• 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
• Implemented different types of replication models: Snapshot, Merge and Transactional.
• Experience with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS. Developed reports using SQL Server Reporting Services (SSRS).
• Fluent in SQL Commands for resolving 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.

TECHINCAL SKILLS:

Database: Microsoft Access, SQL Server 7, 2000, 2005, SQL 2008, 2017

Web Servers: IIS 4.0/5.0, 6.0, WebSphere 5.0

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

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

Applications: Active Directory, MSCS Clustering, hyper,IIS

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

Languages: Transact-SQL, ASP, VB/JavaScript

WORK 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.
• Supported over 100 SQL 2000/2005 databases in 5 node clustering environment (A/P A/A) including database mirroring on critical databases and databases 400+ Gig in size
• Successfully Upgraded SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008
• Designed, implemented, configured SQL 2008 DEV/QA environment on 2 node A/P cluster environment.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy
• 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
• Manage and resolve trouble tickets (Web Track) for database-related issues submitted by customers
• DBA for SQL Server serving over 180 databases and one instance of Sybase servers. 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 proc 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 2000 and 2005. Determined the SQL 2005 installation options. Tested the Installation of SQL 2005 Server.

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 100 SQL 2000/2005 databases in 5 node clustering environment (A/P A/A) including database mirroring on critical databases and databases 400+ Gig in size
• Successfully Upgraded SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008
• Designed, implemented, configured SQL 2008 DEV/QA environment on 2 node A/P cluster environment.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Created snapshot of mirror database for reporting
• Configured and maintain transactional, 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 2003.
• Configured SSIS services, Database Mail, NETIQ Monitoring and Alerts on cluster.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2000 to MSSQL 2005.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2000 & 2005.
• Created DDL triggers for auditing any DDL change in SQL 2005
• Implemented data 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.
• Determined hardware and software requirements for SQL Server version 2000 and 2005. Determined the SQL 2005 installation options. Tested the Installation of SQL 2005 Server.

Environment: Windows 2003/2008, SQL 2000/2005/2008 , T-SQL, Replication, SSIS, SSRS, Database mirroring, MS clustering, Lite Speed, MOM 2005/2007, NETIQ, HP SM7

Confidential, Woonsocket, RI

Sr. SQL Server DBA

Responsibilities:

• Responsible for providing 24 X 7 critical production support to 50+ Production, development and clustered servers.
• Implemented and maintained high availability systems (clustering, database mirroring, log shipping)
• Successfully migrated 200 SQL 2000 databases to SQL 2005
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2000 to MSSQL 2005.
• Create, deploy, configure and monitor complex ETL/SSIS packages Wrote stored proc to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization
• Automated daily backup/restore processes, implemented batch jobs to automate DBA maintenance tasks.
• SQL Server 2005 clustering on Windows 2003/2008 cluster environment for high availability.
• 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
• Manage and resolve trouble tickets (Web Track) for database-related issues submitted by customers.

Environment: Windows 2003/2008, SQL server 7/ 2000/2005/2008 , T-SQL, Replication, Log shipping, failover clustering, Lite Speed, Sybase, T-SQL, Replication, Log shipping, failover clustering, DB Artisan, Idera (SQL Safe, SQL compliance manager)

Confidential, Denver CO

Sr. SQL Server DBA

Responsibilities:

• DBA for SQL Server serving over 180 databases and one instance of Sybase servers. 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 proc to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization
• Technical Lead in charge of migrating over 180 databases from SQL Server 7.0 to SQL Server 2000 using DTS and Embarcadero DB Artisan 8.0, 8.1
• Designed DR database backup and restore plan. Researched and implemented a recovery plan to a point in time failure 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, SQL Mail Manage small, medium and large SQL Server 2000 projects.
• 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.
• Manage and resolve trouble tickets (Peregrine service center) for database-related issues submitted by customers.

Confidential

Software Developer

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.
• Participated in developing the online transaction system.
• Developed Login/Registration/Edit of user profile integration with community sites using HTML5, CSS3, jQuery AJAX, JSON and JavaScript.
• 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.
• front-end / JavaScript, jQuery and AJAX / PHP / CSS3/ HTML5.
• 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 .

Environment: SQL Server 2008, Autosys, JIRA and UNIX