Senior Technical Consultant Resume
SUMMARY:
Around 14+ Years of experience as MSSQL DBA in IT industry for a variety of clients. Energetic, self - motivated team player/builder and enthusiastic worker willing to work in challenging environments.
MAIN SKILLS:
- Primary Database Design / Support on MSSQL
- Hands-on experience in Cloud Azure, SQL Server 2000/2005/2008 R 2/2012/2014/2016 in development/production environment including installing, configuring, upgrading, maintenance, query tuning, troubleshooting, backup/restore, etc.
- Secondary Database Support Sybase
- Sybase Adaptive server support: 12.5 & 15.0.3 Development
- VBScript / PowerShell
- Expertise in Azure Cloud, MSSQL, Sybase, good scripting knowledge on windows PowerShell, VBSCRIPT,
PROFESSIONAL EXPERIENCE:
Senior Technical Consultant
Confidential
Platforms Used: Windows Server 2008 R2 / Windows Server 2012 R2 / Windows Server 2016
Tools: Used Azure Portal, MS SQL Server 2005 / 2008 R2 / 2012 / 2014 / SQL 2016, Data Center
Responsibilities:
- Configure monitor for entire Munich Re Azure estate
- Resizing VM, increasing disk size of existing VM and adding Tags to VM.
- Moving a VM from one Resource Group to another Resource Group.
- Managing Incidents and Service Request in Summit Tool with SLA.
- Supporting App team with necessary Change / Service Request support
- Configure ASR and configure Dashboard and Monitoring alerts
- Support cross tower for any dependencies on Azure
- ØMSSQL L3 with technical hands-on SQL 2008 / 2008 R2 / SQL 2012 / SQL 2016
- Clustering \ Always on High availability Mirroring Replication | Log-shipping
- Complete coordination with team members Cross Towers
- Database Migration activity Legacy to VM
- Database Upgrade activity Lower version to Higher version
- Legacy to Cloud Azure migration
- Change Management
- Incident Providing a RCA
- Problem Management
- Supported the data center with hands & feet support
- Inventory Management
- Configuration of RJ45 & configuration / Cable testing
- Switch panel termination
- Network Cabling
Lead Database Administrator
Confidential
Platforms Used: Windows Server 2008 R2 / Windows Server 2012 R2
Tools: Used: MS SQL Server 2005 / 2008 R2 / 2012 / 2014
Responsibilities:
- MS SQL Server (L3 + ) support and managing the team
- Third Party tool
- TSM Backup / Data domain
- SQL Database Administration and Analyst
- Ensure a smooth and seamless integration of Confidential with Confidential and maintain an undisrupted delivery of IT services to ATCO Group
- Closely working with designer team with planning and project deliverables on SQL 2012 / SQL 2014 database servers.
- Being a part of project deliverables supporting below projects
- Working with designer and proposing a high level planning
- Planning on HADR, DR Services
- Installation, configuration, up gradation and patching of SQL server.
- Managing Instance
- Monitoring Database Performance using Data Dictionaries and Performance Views
- Proof of concepts on SQL Server Architecture
- Database tuning, performance monitoring and troubleshooting.
Lead Administrator and Analyst
Confidential
Platforms Used: Windows 2003 / 2008 R2 / Windows Server 2012 R2
Tools: Used: MS SQL Server 2000/ 2005 / 2008 R2 / 2012
Responsibilities:
- Working with IBM SME’s, documenting the current environment in Confidential standard document “SMTD” and training the offshore team members.
- Planning on HADR, DR Services
- Installation, configuration, up gradation and patching of SQL server.
- Managing Instance
- Monitoring Database Performance using Data Dictionaries and Performance Views
- Proof of concepts on SQL Server Architecture
- Database tuning, performance monitoring and troubleshooting.
- Working on Azure environment (Undergoing extensive training in Wipro)
- Onshore and Offshore model successfully managed and proved in many Confidential account.
- Trained rookies and L1 people in projects.
- Transition Knowledge (KAP / KAP Playback session / SMTD preparation / SOP’s / EPD document closely worked with Process consultant)
- Auditing & risk compliance regulatory procedures.
- Client facing role / coordinating with Vendor to resolve issues.
Lead Database Administrator
Confidential
Platforms Used: Windows Server 2008 R2 / Windows Server 2012 R2
Tools: Used: MS SQL Server 2005 / 2008 R2 / 2012 / 2014
Responsibilities:
- Working with designer and proposing a high level planning
- Planning on HADR, DR Services
- Installation, configuration, up gradation and patching of SQL server.
- Managing Instance
- Monitoring Database Performance using Data Dictionaries and Performance Views
- Proof of concepts on SQL Server Architecture
- Database tuning, performance monitoring and troubleshooting.
Senior Engineer Database Administrator
Confidential
Platforms Used: Windows Server 2003 / Windows Server 2000 / Windows Server 2008 R2
Tools: Used: MS SQL Server 2005 / 2008 R2
Responsibilities:
- Installation, configuration, up gradation and patching of SQL server.
- Managing Instance
- Monitoring Database Performance using Data Dictionaries and Performance Views
- Proof of concepts on SQL Server Architecture
- Database tuning, performance monitoring and troubleshooting.
Senior Engineer Database Administrator
Confidential
Platforms Used: Windows Server 2003 / Windows Server 2000 / Windows Server 2008 R2
Tools: Used: MS SQL Server 2005 / 2008 R2
Responsibilities:
- Installation, configuration, up gradation and patching of SQL server.
- Managing Instance
- Monitoring Database Performance using Data Dictionaries and Performance Views
- Proof of concepts on SQL Server Architecture
- Database tuning, performance monitoring and troubleshooting.
- Log Shipping
- Active / Active and Active / Passive Windows Clustering.
- Implementing backups (hot & cold back-ups) along with disaster recovery, exporting / importing databases, monitoring procedures and ongoing support.
- Preparing Backup/Recovery plan and its implementation
Senior Engineer Database Administrator
Confidential
Platforms Used: Windows Server 2003 / Windows Server 2000 / Windows Server 2008
Tools: Used: MS SQL Server 7.0 / 2000 / 2005 / 2008
Responsibilities:
- Installation, configuration, up gradation and patching of SQL server.
- Creating Databases
- Managing Instance
- Perform periodic Database health check
- Monitoring Database Performance using Data Dictionaries and Performance Views
- Maintaining Data integrity, Password Security and Resources
- Managing Users/Schemas and its privileges and roles
- Implementing database auditing and managing it
- Loading data in various formats in Database using DTS Packages.
- Proof of concepts on SQL Server Architecture
- Database tuning, performance monitoring and troubleshooting.
- Resolutions of database start up problems
- Log Shipping
- Active / Active and Active / Passive Windows Clustering.
- Implementing backups (hot & cold back-ups) along with disaster recovery, exporting / importing databases, monitoring procedures and ongoing support.
- Preparing Backup/Recovery plan and its implementation
- Performing User managed backup/recovery (Complete/Incomplete)
- Monitoring log transport and log apply services
Senior Engineer Database Administrator
Confidential
Platforms Used: Windows Server 2003 / Windows Server 2000
Tools: Used: MS SQL Server 2000 / 2005, Sybase ASE 12, Sybase ASE 15, iWatch
Responsibilities:
- Installation, configuration, up gradation and patching of SQL server.
- Creating Databases
- Managing Instance
- Perform periodic Database health check
- Monitoring Database Performance using Data Dictionaries and Performance Views
- Maintaining Data integrity, Password Security and Resources
- Managing Users/Schemas and its privileges and roles
- Implementing database auditing and managing it
- Loading data in various formats in Database using DTS Packages.
- Proof of concepts on SQL Server Architecture
- Database tuning, performance monitoring and troubleshooting.
- Resolutions of database start up problems
- Implementing backups (hot & cold back-ups) along with disaster recovery, exporting / importing databases, monitoring procedures and ongoing support.
- Preparing Backup/Recovery plan and its implementation
- Performing User managed backup/recovery (Complete/Incomplete)
- Monitoring log transport and log apply services
- Providing L1, L2 support for Sybase ASE Databases.
- Monitoring and configuring server configuration parameters (memory etc.)
- Creating /Dropping databases, its capacity planning and setting Database Options
- Managing Database disk space (data & log) with respect to fragmentation and growth
- Administering Database access, users and implementation of object permissions through groups and roles
- Performing DBCC on databases on daily and weekly basis and fixing any database inconsistency
- Planning and performing backups
- Perform periodic Database server and Backup server health check
- Proactively monitoring block errors, long running transaction, logsuspends
- Performing DR testing on the critical servers on periodic basis
Engineer Database Administrator
Confidential
Environment: Supporting Win2K Server, VB/ASP/VBScript/JavaScript/HTML/XML/IIS 5.0/COM/COM+/SQL Server 2000 / SQL Server 2005. ( SSRS )
Responsibilities:
- Installing, Administering, Configuring, Troubleshooting SQL Server 2000- 2005 databases
- Managing Servers and Clients
- Installing and configuring Server and Client components
- Setting server wide and client configurations
- Manage space for File group.
- Carrying out Optimization / Maintenance Plans
- Database consistency check
- Rebuild Indexes
- Gather Statistics
- Implementing Back-up and Restoration (Command and GUI based)
- Working with Full, DIFFERENTIAL, FILES, FILEGROUPS and Transaction Logs backup
- Recovering Database up-to POINT-IN-TIME and POINT-OF-FAILURE
- Monitoring and Troubleshooting SQL Server:
- SQL Profiler, Trace Flags, Error Logs, T-SQL and Alerts
- Managing SQL Server Security
- Managing Fixed Server and Database roles
- Creating and Managing User defined Roles and permissions
- Designing and Developing Database objects
- Tables, View
- Stored procedures, functions
- Triggers and Indexes
- Implementing Jobs and DTS/SSIS packages
- Writing Cross server DTS/SSIS packages for Transformations and processing the data residing on Homogeneous/ Heterogeneous databases
- Managing Linked and Remote servers
- Maintaining Standby Database using Log Shipping
- Implementing Replication Between SQL Servers
- Database Migration from SQL 2000 to 2005
- Query Fine Tuning on Demand Basis
- ASP Web Page customization as required.
- Manage Backup and retention policy for all Servers