SUMMARY:

• 11years of IT experience as Microsoft SQL SERVER DBA.
• I have thorough knowledge of MSSQL Server 2005, 2008, 2008R2, 2012and 2014 on windows Standalone systems, Windows cluster and VERITAS cluster servers. Good knowledge on windows platform Operating systems, hands on experience in planning, designing, implementing, backups, restore, clustering, creating and maintaining jobs for automating MSSQL Server, Configuration and maintenance of Disaster Recovery and High Availability features in MSSQL Server.
• Good handling capability in Space management.
• Thorough day to day experience on maintenance of critical SQL Server 2000, 2005, 2008, 2008 R2, 2012 and SQL Server 2014 databases.
• Participates as a member of the Infrastructure team, in identifying and recommending improvements to systems and processes within the team to ensure flexible and responsive delivery.
• Performs complex database administration assignments essential to the production and development of DBMS applications.
• Designs, implements, documents, and maintains an enterprise support environment for multiple database instances. Documents all database administration guidelines, standards and procedures in a run - book and ensures that the run-book is followed in all situations.
• Responds to complex customer-reported systems problems.
• Evaluates and recommends use of software (including new DBMS versions and service packs), tools, guidelines, and procedures.
• Ensures that all aspects of the DBMS are properly security, at the right level of granularity, according to security policies. Audits security and user activities on a regular basis in order to ensure compliance.
• Develops database solutions by designing proposed system—defining database physical structure and functional capabilities, security, backup, and recovery specifications.
• Installing MSSQL server 2000, 2005, 2008R2, SQL Server 2012 and SQL Server 2014 on standalone, Windows Clusters and VERITAS cluster servers. Meets business needs by developing stored procedures, user-defined functions, triggers, data transfer/ETL packages, reports, data extracts, etc.
• Installations of Service Packs, patches and cumulative updates on SQL Server all versions.
• Through knowledge on High availability like windows/SQL Clustering, Replication and Mirroring.

PROFESSIONAL EXPERIENCE:

Confidential, Norristown, PA

Sr. SQL Server DBA

Environment: SQL Server 2005, 2008 R2, 2012, 2014 and 2016.

Responsibilities:

• Handled 1000+ production Servers
• IDERA Diagnostic Manager Tool installed on all the production servers and configured BPPM tool to trigger alerts to the DBA email via HPSM ticketing tool.
• Performed key role in handling Production database server during business hours and NON Business hour at ONSITE in a 24/7 support environment.
• Responsible for all database related issue in production servers
• Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring, Indexing, etc.
• Installing, Administering and maintaining High availability solutions like Log shipping, Mirroring, Failover Cluster, Replication and Always ON(Combination of both Mirroring and Failover Clustering)
• Incident Management, Change Management using HPSM tool.
• Weekly/Monthly Maintenance tasks like Patching, installing Service Packs
• Database related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases, point in time recovery etc.
• OS Related tasks like Rebooting Servers, analyzing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etc.
• DB Performance monitoring using tools like IDERA, Profiler, Performance Counters,
• Implementing Service Improvement Plans like Preparing Monitoring Scripts, Disk space alerts script etc.
• Performed migration of the databases from SQL Server 2000 to SQL Server 2008 R2; SQL 2005 to SQL 2012; 2008 R2 to SQL 2014 in a cluster environment.
• Set up transparent database encryption on SQL Server databases.

Confidential, Mountain View, CA

Database Engineer

Environment: SQL Server 2005, 2008 R2, 2012, 2014

Responsibilities:

• The work involves Repairing, Rebuilding servers, Hardware Maintenance & handling incidents in Hotmail properties.
• Analyze server failures that resulted from hardware and/or software failures, and perform repair operations using applicable documentation and coordinating hardware replacement with Site Services.
• Taking manual backups and restoring to backup server during outage scenarios. Rebuild and/or install Operating System, Application, Monitoring tools, SQL Server and storage configuration. Work is to be performed with coordination of Windows Service Web Communications teams including but not limited to System Engineering team, development team, Lab service and Site services
• Working on DB issues feasibility study and implementation processes on Windows backend SQL production servers.
• Documenting Trouble Shooting Guides (TSGs) on new issues and giving KT to the offshore team.
• Track and report replacement hardware usage statistics and trend.
• Track and report on server hardware failure rates for every server SKUs and components.
• Coordinate hardware replacement and ensure appropriate inventory levels are maintained for every server/cluster in all data centers.
• Participate in High Priority conference calls to address production issues when requested.
• Install monthly/emergency security patches, SQL hotfix, Windows hotfix, lPAK’s, perform Service account password reset, renewal/setup of SSL certificates and other regular database maintenance work.
• Co-ordinate server maintenance activities with internal Microsoft support teams.
• Participating in weekly and monthly service delivery meetings with the customer.
• When Microsoft introduces new tools to manage the deployment process, train, accept and adopt these tools as requested by Microsoft
• Track, maintain and report deployment related key performance indicators (KPI) on Efficiency, Quality, and Volume
• Participate in Feature Specification and Release Reviews to ensure complete understanding of the features being deployed.
• Work on automation scripts using Windows PowerShell.
• Migrated the databases from SQL Server 2000 to SQL Server 2008 R2 in a cluster environment and SQL 2005 to SQL 2012; 2008 R2 to SQL 2014.

Confidential

SQL Database Consultant

Environment: SQL Server 2005, 2008 R2, 2012, 2014

Responsibilities:

• Installed SQL Server 2012 on a 2 node Windows cluster.
• Installed SQL Server 2008 R2 on a 2 node Windows cluster.
• Performed key role in handling Production database server during business hours at onshore
• Responsible for all database related issue in production servers
• Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring, And Re-indexing etc.
• Installing, Administering and maintaining High availability solutions like a) Log shipping b) Mirroring c) Always ON Availability Group on Windows Failover Cluster d) Replication
• DB Performance monitoring using tools like Profiler, Perf Counters,
• Migrated the databases from SQL Server 2000 to SQL Server 2008 R2 in a cluster environment.
• Configured transactional, snapshot and merge Replication
• Created Database Backup and Recovery procedures
• Design, optimize, and maintain all relational databases and ensure proper operational uptimes
• Develop, test, and deploy database standards, processes and procedures
• Preparing Document failures and the corrective actions
• Stage, test, and document all database upgrades
• Maintain a good work relationship with customers and vendors
• Ensure 100% adherence to all IT and department policy, processes and procedures
• Basic understanding on SSIS, SSRS (Reporting Services) and Analysis Services
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity.
• Database consistency checks using DBCC
• Tuning and Optimization of Transact - SQL, Stored Procedures
• Experience in creating databases based on functional requirements and system design
• Author professional correspondence to customers and vendors.

Confidential

SQL Server Project DBA

Environment: SQL Server 2005, 2008 R2, 2012.

Responsibilities:

• Worked on VERITAS Cluster Production Servers with SQL Server 2005 and SQL 2008 R2.
• Worked as a Project DBA with different application teams to build SQL Server for critical applications in a banking environment.
• Followed change management system for all the planned activities scheduled on PROD, DR, TEST and DEV servers. Followed the process for BMC Remedy change management system for Change approvals by attending CAB meetings and convincing change managers.
• Performed key role in handling Production database server during business hours at onshore
• Responsible for all database related issue in production servers
• Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring, indexing etc.
• Installing, Administering and maintaining High availability solutions like a) Log shipping b) Mirroring c) Failover Cluster d) Replication
• Incident Management, Change Management using Remedy
• Weekly/Monthly Maintenance tasks like Patching, installing Service Packs
• Database related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases, point in time recovery etc.
• OS Related tasks like Rebooting Servers, analyzing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etc.
• DB Performance monitoring using tools like Profiler, Perf Counters,
• Implementing Service Improvement Plans like Preparing Monitoring Scripts, Disk space alerts script etc.
• Migrated the databases from SQL Server 2000 to SQL Server 2008 R2 in a cluster environment.
• Experience in Light Speed Backup Tool and IDERA diagnostic manager
• Monitoring the CPU, Memory utilization on servers.

Confidential

SQL SME; Account: Microsoft and BP.

Environment: SQL Server 2005, 2008 R2, 2012.

Responsibilities:

• As a part of PSITOPS team we supported 4000+ Servers with terabytes of data. It was a critical environment where we had Microsoft Operation Manager (MOM 2005 and MOM 2007) alerting system on all the servers. Based on the alerts, the tickets were created and assigned to our queue. The alerts consisted of backups failures, log file full, data file full, cluster failures, replication failures, Log shipping and mirroring issues, blockings, performance issues. This project had huge visibility across Microsoft comprising of director level people. It’s very important to have all the SLA met.
• We have almost met 100% SLAs metrics on daily basis so far with no operational failures. The environment is a complete integration of SSIS, SSRS, SSAS and SQL SERVER 2005, 2008, 2008 R2 databases.
• Performed key role in handling Production database server during peak times.
• Responsible for all database related issue in production servers
• Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring, Indexing, etc.
• Installing, Administering and maintaining High availability solutions like
• Log shipping
• Mirroring
• Failover Cluster
• Replication
• Incident Management, Change Management using Remedy
• Weekly/Monthly Maintenance tasks like Patching, installing Service Packs
• Database related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases, point in time recovery etc.
• OS Related tasks like Rebooting Servers, analyzing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etc.
• DB Performance monitoring using tools like IDERA, Profiler, Performance Counters,
• Implementing Service Improvement Plans like Preparing Monitoring Scripts, Disk space alerts script etc.
• Created technical documents and SIP (Service improvement plans) to monitor the failures.
• Created SQL Server technical documents for the team which was very useful to train the new joiners.
• As there were no 3rd party monitoring tools in this account, we have created SQL Server alerts using the DB mail to check the below issues: -
• Ensure Database Availability
• Verify Successful Database Backup Execution
• Verify Successful Transaction Log Backup Execution
• DISK SPACE MONITORING
• Monitor database and transaction log file sizes.
• Check the database log for errors
• Verify the DB is set up for email notification and is operational.
• Check for any Cluster related error
• Replication Sync Status
• Actively participated in the Disaster Recovery Drills in the weekends (every six months) to ensure that the DR is ready to be switched as production.
• Completed SQL Server 2008 R2 and SQL 2012 Cluster installation.