SUMMARY:

• Over 9 years of IT experience with more than Five years in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2016, 2014, 2012, 2008/R2, 2005, MS SQL Server 2000 in Production, Test, Development Replication& Cluster Server Environments.
• Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and unclustered environments
• Good Knowledge in Design and document Logical and Physical data models.
• Designing and documentation of SQL Server Strategies and plans.
• Knowledge of Relational Database Management Systems (RDBMS).
• Experience in Database Backup, Recovery and Disaster Recovery (DR) procedures.
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Experience in setting up and managing of Replication.
• Experience in installation, configuration of MS SQL Server on Windows NT, and 2000/2003/2008 and R2 servers.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Hands on experience in Troubleshooting database issues using SQL Server tools like Perfmon, Profiler, and System stored procedures.
• Hand on experience in writing and debugging Stored Procedures and triggers.
• Experience in system tables and stored procedures using T - SQL.
• Experience on Database Designing, Data warehousing (Star Schema and Snowflake Schema).
• Experience in working with Windows 2000/2003 Advance Server and Windows NT Server.
• Experience in Data Modeling using Erwin Design Tool.
• Good Interpersonal, Analytical and Communication skills.
• Experience in working with version controlling tools like VSS for managing SQL scripts and changes that are going to production.
• Experience working with Windows 2000/2003 Advanced Server - Administration and Installation.
• Experience in Installing and Configuring Cluster SQL Servers in Active/Passive or Active/Active in SQL server 2000 /2005.
• Implemented customized log shipping for SQL Server 7.0 and built in log shipping with SQL Server 2000 and 2005.
• Implemented proactive monitoring scripts for production databases.
• Worked with Popular monitoring tools like NETIQ App manager, SQL Profiler, Idera Diagnostic Manager, Windows Perfmon and performance counters for Tuning MS SQL Performance
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Hands on experience in Troubleshooting database issues.
• Hand on experience in writing and debugging Stored Procedures and triggers.
• Experience in system tables and stored procedures using T-SQL.
• Prepared Disaster recovery plans and procedures for SQL Server Databases in Production environment.
• Experience on Database Designing, Data warehousing (Star Schema and Snowflake Schema).
• Good Understanding of RAID Technologies.
• Good understanding of Change Control Management and followed the same in implementing Changes to Production database in previous projects.
• Implemented Third Party solution (Litespeed) for SQL Server back and increased back up and restore performance.
• Experience in Data Modeling using Erwin Design Tool.

TECHNICAL SKILLS:

Languages: C, T-SQL, PL/SQL, XML, HTML Script, VB script

RDBMS: MS SQL Server 2016, 2014, 2012, 2008/R2,2005, 2000, 7.0, MS-Access

Front End: MS Visual Basic, ASP.NET

OLAP Tools: MS OLAP Services Manage

Data Modeling Tools: Erwin 3.0, 4.1, Visio 2003, 2002, 2000

Version Ctrl Tools: Rational Clear Case, Visual Source Safe

Operating Systems: Windows 2000/2003/2008/ R2 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, UNIX/LINUX

Other Tools: Idera Diagnostic Manager, NetIQ, Quest Spotlight, SQL Light speed, Crystal Reports, Lumigent Log Explorer

Hardware: Compaq Proliants 8000, 6500, 6000, 5000 Servers, HP DL 360

PROFESSIONAL EXPERIENCE:

Confidential, Orangeburg, NY

Project Support DBA (Project / Production admin)

Responsibilities:

• Responsible for provide 24 X 7 mission critical support to 250 Production and development farms including cluster servers.
• Supported and maintained 80 mission critical applications.
• Successfully upgraded and migrated multiple SQL 2008 /R2 to 2012 and 2014 and 2016
• Setup and configured SQL Azure.
• Migrated data from onsite data center to SQL Azure with bacpac and SSIS packages.
• Setup and configured Geo-Replication on SQL Azure across different geographical locations.
• Well versed with Data Masking and Data encryption on SQL 2016 and SQL Azure.
• Experienced with Amazon RDS, EC2 and S3 services. Migrated data from On premise to RDS.
• Consolidated multiple SQL machine into 1 SQL 2014 box running on VNX machine.
• Installed multiple SQL Server 2014/ 2012 / 2008 R2 / 2005 in stand alone and clustered configuration. Planned, configured, tested and implemented failover cluster on MS Windows 2003, 2008 and 2012.
• Setup and configured HADR/ always on solution in SQL 2012 and SQL 2014 on windows 2012 and windows 2016 server
• Monitored and failed over primary replica in Always on to secondary replicas.
• Tested and Applied latest service packs and cumulative Hotfix for SQL 2016/ 2014/ 2012 / 2008- R2 / 2005 including R2.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2005 to MSSQL 2008 and 2012 and 2014.
• Installed and configured SQL 2008/2012/2014 and 2016 Report and Analysis Services.
• Performed quarterly DR drill across datacenters
• Facilitated SQL server 2008 R2, SQL 2012 and sql 2014 server migration in Datacenters
• Configured and maintain a Microsoft SQL server 2008/R2 / 2012 and 2014 fail over clusters.
• Created the backup and restore strategy for production, development and test environments.
• Created maintenance plan for database consistency and optimization.
• Configured and maintain transactional replications.
• Installed, configured and maintained Log shipping to create Standby Server.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Created snapshot of mirror database for reporting
• Involved in Disaster recovery and created the documentation.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2000/2005/2008 /2012 and 2014.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Configured SSIS services, Database Mail, NETIQ Monitoring and Alerts on standalone/cluster.
• Configured Linked server for application team to run adhoc queries
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data
• Designed and deployed SSIS packages in production environment to implement business logics.
• Document server and database policies and procedures.
• Involved in Change Management, Problem management activities using Service Now tool before implementing database changes in production and development activities.
• Determined hardware and software requirements for SQL Server version 2000/2005/2008 /2012 and 2014. Determined the SQL 2005 installation options. Tested the Installation of SQL 2005 / 2008 / 2012 /2014 Server.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Install and configure postgres 10.2 on linux centos
• Well versed with pg basebackups, and pg dump Replication and PITR in postgres
• Upgraded from 9.6 to 10.0 version of postgres
• Installed and configured pgAdmin and is it for postgres administration remotely
• Solid experience in Postgres security using pg hba file.
• Used SCOM for monitoring and TSM / TDP for database backups

Confidential, Tempe, AZ

Responsibilities:

• Responsible for provide 24 X 7 mission critical support to 250 Production and development farms including cluster servers.
• Supported and maintained 80 mission critical applications.
• Successfully upgraded and migrated multiple SQL 2008 /R2 to 2012 and 2014 and 2016
• Setup and configured SQL Azure.
• Migrated data from onsite data center to SQL Azure with bacpac and SSIS packages.
• Setup and configured Geo-Replication on SQL Azure across different geographical locations.
• Well versed with Data Masking and Data encryption on SQL 2016 and SQL Azure.
• Experienced with Amazon RDS, EC2 and S3 services. Migrated data from On premise to RDS.
• Consolidated multiple SQL machine into 1 SQL 2014 box running on VNX machine.
• Installed multiple SQL Server 2014/ 2012 / 2008 R2 / 2005 in stand alone and clustered configuration. Planned, configured, tested and implemented failover cluster on MS Windows 2003, 2008 and 2012.
• Setup and configured HADR/ always on solution in SQL 2012 and SQL 2014 on windows 2012 and windows 2016 server
• Monitored and failed over primary replica in Always on to secondary replicas.
• Tested and Applied latest service packs and cumulative Hotfix for SQL 2014/ 2012 / 2008- R2 / 2005 including R2.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2005 to MSSQL 2008 and 2012 and 2014.
• Installed and configured SQL 2008/2012/2014 Report and Analysis Services.
• Performed quarterly DR drill across datacenters
• Facilitated SQL server 2008 R2, SQL 2012 and sql 2014 server migration in Datacenters
• Configured and maintain a Microsoft SQL server 2008/R2 / 2012 and 2014 fail over clusters.
• Created the backup and restore strategy for production, development and test environments.
• Created maintenance plan for database consistency and optimization.
• Configured and maintain transactional replications.
• Installed, configured and maintained Log shipping to create Standby Server.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Created snapshot of mirror database for reporting
• Involved in Disaster recovery and created the documentation.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2000/2005/2008 /2012 and 2014.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Configured SSIS services, Database Mail, NETIQ Monitoring and Alerts on standalone/cluster.
• Configured Linked server for application team to run adhoc queries
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data
• Designed and deployed SSIS packages in production environment to implement business logics.
• Document server and database policies and procedures.
• Involved in Change Management, Problem management activities using Service Now tool before implementing database changes in production and development activities.
• Determined hardware and software requirements for SQL Server version 2000/2005/2008 /2012 and 2014. Determined the SQL 2005 installation options. Tested the Installation of SQL 2005 / 2008 / 2012 /2014 Server.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.

Confidential, Somerset, NJ

Responsibilities:

• Supported over 200 SQL databases instances in production and pre-production environments (SQL Server 2005, 2008/R2 and 2012)
• Upgraded sql 2005 to 2008 and R2, applied latest service packs and hot fixes
• Facilitated SQL Server 2008/R2 cluster and SQL Server replicating server
• Performed routine maintenance, including backup & recovery in sql server 2008 and R2
• Created and maintained jobs and maintenance plans
• Responsible for Database tuning, creation & design
• Facilitated SQL server 2005 and sql 2008/R2 server migration in Datacenters
• Performed analysis on tables, indexes and code in order to optimize query performance
• Used SQL Profiler and performance monitor to trace database performance
• Use table partitioning to improve system performance over all
• Configured SQL 2008 cluster for mission critical application to provide 24*7 up environment
• Setup and configured SSRS (reporting services) for business
• Installed and configured SSAS (analysis service) for data warehousing
• Setup, configured and monitored log shipping for critical databases
• Installed database mirroring in high performance mode to avoid downtime
• Setup policies in sql 2008 using standard conditions, targets and facet. configured and monitored transactional and merge replication
• Supported SQL Server production & pre-production release roll-outs
• Administer sql server security using sql and windows authentication and setup different proxy account to grant certain permission.
• Configured Linked server for application team to run adhoc queries
• Design & development of Pre-prod/ UAT/ development DB refreshes with Production data
• Transformation and Uploading the information from different platforms into SQL Server databases using DTS, BCP, BULKINSERT and SSIS (integration service) packages
• Worked With storage team to configure and design SAN for databases instance.
• Management of the IIS 7 .Net web farm environment, monitor application pools and system response time, server health, applications deployment, and Disaster Recovery.
• Escalation point for high priority and 3rd level technical support for web application issues.
• Provided management with best practices and operating procedures future application integration with SQL server and IIS web farm
• Experience supporting IIS 6 and 7 web servers and .Net web applications.

Confidential, Stamford, CT

SQL Server DBA/ Developer

Responsibilities:

• Involved in Migration of Sql Server 2005 to SQL Server 2008
• Database capacity planning and Space forecasting.
• Used Erwin Data Modeling tool to design Database Schema and perform validations on existing Databases using Data Validator.
• Database troubleshooting and raising Service request s with MS support and applying patches
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS packages.
• Setup Database Mirroring in SQL Server 2008.
• Configured Transactional Replication between Primary Server and Read-Only servers with separate Distributed server and experience in troubleshooting replication problems.
• Advanced Tuning for SQL Server Transactional replication.
• Helped Development team in Deploying and testing application with SQL Server 2008 as backend.
• Responsible for changed management maintenance: created Stored Procedures scripts, cursors for the applications, tested them on the test server and moved them to production.
• Creating Backup strategies and scheduling them for execution.
• Writing Scripts for monitoring and alerting team through Email and Pager using SQLmail and Customized extended procedures.
• Created and managed transaction replication scripts to re create the replication if required.
• Created Documentation to install Sql server, apply service pack, hot fix on production, Development, testing environments.
• Security User Management, Privileges, Roles, Auditing, Profiling Authentication.
• Generated test data and tested new databases consistency with existing databases to meet the functionalities requirement .Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Development of automated daily, weekly and monthly system maintenance tasks such as Database backups, replication verification, database integrity verification and indexing updates.
• Daily monitoring of Database performance and SQL Jobs and bottlenecks of SQL Server including network related issues with SQL Server.
• Performance tuning and optimization of procedured and queries.
• Worked with SQL Server Profiler to generate traces.
• Used Diagnostic Manager from Idera solutions for monitoring Sql Servers
• Had good experience in 24/7 Production support.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition, Windows 2000 Advanced Server/Windows 2000, 2003 and 2008 Server, HP Proliant Dl585 server, Idera Diagnostic Manager,SQL Lite speed,