We provide IT Staff Augmentation Services!

Senior Technical Consultant Resume

5.00/5 (Submit Your Rating)

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 
  • 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

We'd love your feedback!