Sql Server Service
Resume:
Naveen Manney Email: ****.**********@**********.***
Sr. SQL DBA Consultant Phone: 972-***-****
SUMMARY
A Microsoft Certified (MCSA and MCTS) and Sr SQL Server DBA Consultant with 13 years 6 months of experience in Database Administration/ BI Development for different applications using Microsoft SQL Server 7.0, 2000, 2005, 2008/2008 R2, 2012, 2014, and 2016.
Installation of SQL Server 2000, 2005, 2008, 2012 and 2014, configuring server options, Creating and managing Database for SQL Server. Applying SQL Server latest Service Packs and Security updates.
High availability and recoverability of databases in 24/7 environment by using clustering, replication, mirroring, log shipping, backup and restore to meet RTO/RPO objectives.
Experience deploying, configuring and administering Always On: Availability Groups
Upgrading/Migrating SQL Server to higher versions, 2005, 2008, 2012, 2014.
Strong command of Performance tuning and proven experience in troubleshooting performance problems (Indexing, Optimizer, server configuration, Profiler, DMV etc.) including TSQL programming and debugging skills.
6+ years of experience as a SQL Developer.
6+ years of experience as BI Developer, SSIS packages and SSRS reports building and deployment.
7+ years of experience of leading teams up to size of 25 members and providing technical mentorship, Setting up best practices and improvement plans to meet the SLA’s for the client delivery.
Worked on many Client interfacing roles dealing critical/major incidents and adhering to strict SLA guidelines in a 24/7 production support teams.
Experience in Catalyst ERP system.
Setup DR strategy and support routine DR testing
Managing and Configuring Backup and Recovery strategies for Databases.
Configuring Database and Server level security.
Designing and Developing Qlikview documents.
Experience in Pro2Sql replication tool of ProgressDB, Cyber Query programming and Knowledge in Sales-I financial application tool
Experience as Core Oracle DBA and Power shell scripting.
Knowledge in ITIL Incident Management process as I worked in SQL Incident teams. Performing Health Checks on the database servers, CIRATS. Attended PMP training of 36 hours.
EXPERIENCE:
Currently working as a Sr SQL Server DBA for CIT Group from Feb 2018 till date
Worked as a Sr SQL Server DBA with USLBM from Apr 2016 to Feb 2018.
Worked as a Sr SQL Server DBA with Innovative Information Technologies from Jun 2015 to Mar 2016
Worked as a Sr SQL Server DBA with GBISS Inc from Jan 2015 to May 2015.
Worked as a Lead SQL DBA at IBM from Jan 2011 to Dec 2015.
Worked as a Lead SQL DBA at Infosys Technologies from Mar 2010 to Dec 2010.
Worked as a Senior SQL Server DBA at ADP from Jun 2007 to Feb 2010.
Worked as a Senior SQL Server DBA at Wipro Technologies, from Jul 2004 to Jun 2007.
EDUCATIONAL QUALIFICATIONS:
Master’s Degree in Computer Applications.
Completed MCSA Certification – SQL Server 2012.
Completed MCTS - SQL 2008 Certification (70-432 – Implementation and Maintenance) and MCP Certification (SQL Server 2000).
TECHNICAL SKILLS:
DATABASE
Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008, R2, 2012, 2014, 2016 and Sybase 12.0. (Adaptive SQL versions)
OPERATING SYSTEMS
Windows 2000 Professional, Windows Server 2008/2003, Win 98.Windows ‘95/98/2000/NT, MS-Dos
LANGUAGE
T-SQL, PowerShell, Qlikview, HTML, DHTML, C and C++
SQL SERVER TOOLS
Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS, Symantec NetBackup, DPM Backup tool, FogLight, SQL Sentry, LightSpeed,
TOOLS USED FOR ITIL
BMC Remedy 6.0/6.5, Service Now, CA Service Desk, Maximo, Samanage Tool and HP Service Center.
THIRD PARTY TOOLS
NetBackup Tool, Cyber Query, Qlikview, Lite Speed and Dell Appassure
PROJECT EXPERIENCE
CLIENT- CIT GROUP, Livingston, NJ
Feb 2018 till date
Sr SQL Server DBA
Contributions Include:
Installing, Configuring and Managing Production, Staging and Dev environment SQL Servers.
SQL Server DB Monitoring and troubleshooting alerts
As a L3 Onsite DBA will be point of contact for all the escalated issues.
Managing database backups and ensuring the completion of backups.
Setup and manage Replication
Write and develop T-SQL Scripts.
Performance optimization of the SQL server database processes.
Participate in process and service improvements withing the database management function to improve the overall process performance.
Manage the Always On Availability groups.
Provide resolutions to Critical database related Incidents and implement the change requests as per SLA's.
Working in ITIL service modules(incident, Change, Problem and Release Management) using Service Now tool.
Involved in the DR testing.
Maintaining the SQL Server monitoring using the powershell scripts to collect the performance related, DDL related and deadlock related events.
Client - USLBM, Hammonton NJ
Apr 2016 to Feb 2018
Sr SQL Server DBA
Was a Sr SQL Server DBA handling the USLBM project. As part of the profile below were my contributions.
Contributions Include:
Perform Migration of SQL Server from 2005 to SQL Server 2014 version.
SSIS package creation for extracting the data from the legacy system on ProgressDB to SQL Server.
Developing SSRS reports to cater to the reporting needs of finance, accounts and sales teams.
Troubleshooting database performance issues to improve the SQL Server response time.
Working with different teams to gather the requirements related to reports and data needs.
Maintain the Database backups by developing a strategy to support any disaster situation that might occur.
Involved in migration of legacy data from other ERP systems in to Catalyst ERP system.
Designing and developing Qlikview Dcouments.
Providing the data feeds to the Salesi finance application tool.
Monitor the database and disk usage and ensure the usage is under check
Develop the DR strategy for the Database server recovery
Move the existing Reporting server jobs and build the new ones appropriately
Working on Cyber Query scripts to eliminate old DTS packages.
Working on other tasks that would improve the server availability at all times in future.
Performed Health checks on all the servers and rectified the database and server settings as per standard SQL server recommendations.
CLIENT - USLBM, Hammonton, NJ
Jun 2015 to Mar 2016
Sr SQL Server DBA
Working as a SQL Server DBA handling the USLBM project. below were my contributions.
Contributions Include:
Perform Migration of SQL Server from 2005 to SQL Server 2014 version.
SSIS package creation for extracting the data from the legacy system on ProgressDB to SQL Server.
Developing SSRS reports to cater to the reporting needs of finance, accounts and sales teams.
Troubleshooting database performance issues to improve the SQL Server response time.
Working with different teams to gather the requirements related to reports and data needs.
Maintain the Database backups by developing a strategy to support any disaster situation that might occur.
Involved in migration of legacy data from other ERP systems in to Catalyst ERP system.
Designing and developing Qlikview Dcouments.
Providing the data feeds to the Salesi finance application tool.
Monitor the database and disk usage and ensure the usage is under check
Develop the DR strategy for the Database server recovery
Move the existing Reporting server jobs and build the new ones appropriately
Working on Cyber Query scripts to eliminate old DTS packages.
Working on other tasks that would improve the server availability at all times in future.
Performed Health checks on all the servers and rectified the database and server settings as per standard SQL server recommendations.
CLIENT - RamQuest Inc, Plano, TX
Jan 2015 to May 2015
Sr SQL Server DBA
Worked as a Sr SQL Server DBA handling the legacy T SQL scripts of Ram Quest for performance optimization. Working on Execution plans to fine tune the SQL Scripts. Worked on other general DBA activities as well.
Contributions Include:
Optimizing the T SQL Scripts for improved performance.
SQL Server Installations
Working with Developers in Enhancing the Stored Procedures.
Analyzing the Execution plans and based on it update the Indexes of the tables.
Using Database Engine Tuning Advisor to Optimize the T-SQL.
Modifying the Stored procedures as required.
Configuring the backup strategy.
Configuring the Security.
Analyzing the Data Models using Toad Data Modeler for better Database design and performance.
Monitoring SQL Server Performance using SQL Profiler, Perfmon counters and Index tuning.
CLIENT- DuPont
Jul 2013 to Dec 2014
Account SME for SQL Server DBA
Worked as a Account SME - SQL DBA handling the Dupont project. As part of the profile I was the point of contact for all the Escalations on major incidents. Reviewing the Change Orders of the account and implementing critical changes as Patching and SQL Server Installations. Other issues handled were Database maintenance, Log Shipping setup and troubleshooting, Cluster related issues.
Contributions Include:
Installation of SQL Server 2000, 2005, 2008 and 2012, configuring server options, Creating and managing Database for SQL Server. Applying SQL Server latest Service Packs and Security updates.
Configuring SQL Server 2012 AlwaysOn Availability Groups.
As Account SME the point of contact for all critical issues as well smooth functioning of Incident management team. Leading and mentoring the team technically.
Monitoring SQL Server Performance using SQL Profiler, Perfmon counters and Index tuning.
Configuration of Database Mirroring, Log Shipping and Replication.
Worked on many Transition projects as part of it involved in requirements gathering to setup the SQL Servers according to best possible performance of applications.
Working with development teams to implement new Database design and enhancements to T SQL queries in SQL Server databases as required.
Managing and Configuring SQL Servers as Linked servers, Remote Server. Developing Maintenance Plans for Backing of Databases.
SQL Server Cluster installations.
Setup DR strategy and support routine DR testing.
Knowledge in Power shell scripting.
Developing SSIS packages and SSRS reports.
Performing Health Checks on the database servers, CIRATS for Compliance, Compliance Web Portal.
Managing and Configuring Backup and Recovery strategies for Databases.
CLIENT- Musgrave
Jan 2013 to Jun 2013
Account SME for SQL Server DBA
Worked as a SQL DBA and Oracle DBA handling the Musgrave project.
Contributions Include:
Installation of SQL Server 2000, 2005, 2008 and 2012 configuring server options, Creating and managing Database for SQL Server. Applying SQL Server latest Service Packs and Security updates.
As Account SME the point of contact for all critical issues as well smooth functioning of Incident management team. Leading and mentoring the team technically.
Worked on many Transition projects as part of it involved in requirements gathering to setup the SQL Servers according to best possible performance of applications.
Working with development teams to implement new Database design and enhancements to T SQL queries in SQL Server databases as required.
Backing and Restoring of Databases. Developing Maintenance Plans
Monitoring SQL Server Performance and Activity using Profiler, Perfmon counters.
Developing SSIS packages and SSRS reports.
Configuration of Database Mirroring, Log shipping, Replication.
Monitoring SQL Server Performance using SQL Profiler, Perfmon counters and Index tuning. Performance improvements using Row and Page compression of data.
Managing and Configuring SQL Servers as Linked servers, Remote Server.
SQL Server Cluster installations.
Performing Health Checks (GSD331) on the database servers, CIRATS for Compliance.
Using Power shell scripting.
Supporting core tasks in Oracle DBA team.
CLIENT - Standard Insurance
2011 to Dec 2012
Lead SQL Server DBA and Oracle DBA
Earlier worked as SQL DBA handling the Standard Insurance project.
Contributions Include:
Installation of SQL Server 2000, 2005, and 2008 configuring server options, Creating and managing Database for SQL Server. Applying SQL Server latest Service Packs and Security updates.
As Account SME the point of contact for all critical issues as well smooth functioning of Incident management team. Leading and mentoring the team technically.
Backing and Restoring of Databases. Developing Maintenance Plans.
Working with development teams to implement new Database design and enhancements to T SQL queries in SQL Server databases as required.
Monitoring SQL Server Performance and Activity using Profiler, Perfmon counters.
SQL Server Cluster installations and Service packs installation.
Configuration of Database Mirroring, Log shipping, Replication.
Developing SSIS packages and SSRS reports.
Performance improvements using Row and Page compression of data.
Performing Health Checks (GSD331) on the database servers, CIRATS for Compliance, Performed Server Activation &Deactivation (SA&D).
Using Power shell scripting.
Handling Account compliance issues like Health checks and User validations.
CLIENT - Microsoft
Mar 2010 to Dec 2010
Lead SQL Server DBA
I was leading a SQL DBA’s team handling the Microsoft project that caters to the needs of 3000 servers of MS. Lead the team to a Successful KT transition. The profile involves the latest SQL Server technologies and vast range of troubleshooting scenarios for DBA issues on a day to day basis. The range of issues vary from SQL Server Installations, Log Shipping setup and troubleshooting, Database Mirroring setup and troubleshooting, Replication setup and troubleshooting, Cluster related issues.
Contributions Include:
Handling more than 3000 SQL Database servers of Microsoft.
Leading a team of 25 people and mentoring them technically and making sure that we adhere to the SLA’s in the delivery.
Worked on many Transition projects as part of it involved in requirements gathering to setup the SQL Servers according to best possible performance of applications.
Working with development teams to implement new Database design and enhancements to T SQL queries in SQL Server databases as required.
Installation of SQL Server 2000, 2005 and 2008, configuring server options, Creating and managing Database for SQL Server.
Backing and Restoring of Databases. Developing Maintenance Plans
Providing the daily and monthly team reports (SLA reports, Trend analysis)
Automating SQL Server Administrative tasks using SQL Server Agents by creating Jobs and Alerts.
Configuring and designing Replication.
SQL Server Cluster installations.
Monitoring SQL Server Performance and Activity and troubleshooting.
Configuration of Database Mirroring
Designing and Configuring Log shipping
Managing and Configuring SQL Servers as Linked servers, Remote Server.
Worked in a Incident management team
COMPANY- ADP India
Jun 2007 to Feb 2010
Sr. SQL Server DBA
It was a pilot project where I was the first member on the offshore SQL Server DBA team and was able to successfully complete the Transition of the project and there on seamlessly handled the project without any issues and later was involved in both project scope and team growth.
Contributions include:
Installation of SQL Server 2000 and 2005, configuring server options, Creating and managing Database for SQL Server.
Working with development teams to implement new Database design and enhancements to T SQL queries in SQL Server databases as required.
Worked on many Transition projects as part of it involved in requirements gathering to setup the SQL Servers according to best possible performance of applications.
As a single point of contact frequently interacted with application owners for any enhancements related to SQL Server applications.
Automating SQL Server Administrative tasks using SQL Server Agents by creating Jobs and Alerts.
Backing and Restoring of Databases. Developing Maintenance Plans
Monitoring SQL Server Performance and Activity
Managing and Configuring SQL Servers as Linked servers, Remote Server.
Designing and Configuring Log shipping
Tuning Databases for performance
Configuring and designing Replication
Working Knowledge of SQL Server Cluster.
Basic SQL and T/SQL knowledge
Worked in an Incident management team and have the knowledge on Incident and Change management processes.
CLIENT- Microsoft
Jul 2004 to Jun 2007
Production Support Analyst (SQL DBA)
GMP (Global Marketing Platform) includes – MAPSS, EMMA, CMT, and WWE - that serve as tools for Microsoft Finance and Marketing professionals worldwide. MAPSS (Marketing, Analysis, and Planning Support System) is one of the subsystems of Project Mosaic used by Microsoft finance and marketing professionals to plan, implement, and track budget, marketing initiative and campaigns. EMMA (Enterprise-Wide Marketing Management Application) is a CRM tool built on the capabilities of epiphany, used in data analysis, opportunity mining, campaign planning, and campaign execution of Individuals & Organizations of Microsoft customers. WWE (World Wide Events) is an event management system that enables the effective management of events worldwide as part of the overall Microsoft product promotion campaigns.
Contributions include:
Managing and Configuring SQL Servers as Linked servers, Remote Server and configuring for fail over Support as well as setting the configuration options
Monitoring Jobs and Alerts.
Monitoring SQL Server Performance and Activity
Backup and Restore of Databases
Setting up Database Maintenance Plans.
Providing the users with customized stored procedures as and when requested.
Monitoring and maintaining the SQL jobs running on various SQL Server boxes.
Monitoring the Log shipping between Productions – Reporting as well as Production –UAT boxes.
Refreshing UAT and Reporting instances with production data.
Contact this candidate