OBJECTIVE:

• To synergize all my strengths and resources available to work with complete perfection and professionalism in the IT Industry in a challenging manner that can extract and enrich my creativity and performance.

SUMMARY

• Over 16+ Years of IT experience in Administration, Analysis, Design, Coding, Testing, and Implementation and 2+ years in Enterprise Architecture .
• 15+ Years of extensive experience in MS - SQL Server Administration and Development including Design and implementation of Databases, planning/ implementing backup/ recovery strategies, and Performance tuning, consolidation Project, migration project, upgrade project.
• Enterprise Architecture Object Modelling using TOGAF framework.
• Served as a CAB Manager under the Enterprise Change Management Team to review changes.
• Collected and Designed Integration Taxonomy and Diagrams of Applications and the dataflow and touchpoint associated with the Integration under the Enterprise Architecture Team
• Designed Taxonomy and Developed TRM (Technology Reference Model) for the Organization under the Enterprise Architecture Team.
• Managed and maintained the EA repository
• DB Architecture, Design, Implementation of SQL Server Farm (SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017).
• Implemented SQL Server AlwaysOn High Availability Groups for Critical Databases for different Business Units.
• Architecting, Designing and Implementing Solutions for the Corporate Infrastructure Applications in the private corporate cloud.
• 6+ Years of experience in managing, mentoring and training a team of 10 DBA’s (SQL Server, Oracle) as a Technical Team Lead and aligning DB resources for round the clock availability.
• Designing process and procedures for the DBA team.
• Documenting the process flow and life-cycle of various regular DBA activities.
• Adherent to the ITIL practices and Service Level Agreements.
• Managing multiple projects.
• Designed Failover / Disaster Recovery strategy from a DB perspective.
• Specialist in DB Migration project (Datacenter to Datacenter, Older version to new version of SQL Server).
• Excellent skills in database backup, recovery and restoration.
• Experience in designing relational database model and implementation as per business requirement
• Competitive in writing Stored Procedures, Triggers and Cursors using T-SQL.
• Competitive in tuning procedures and queries for maximum performance.
• Involved in performance tuning of very complex SQL statements and procedures.
• Competitive in trouble-shooting (handling database corruption and Suspect Mode, transaction log problems, Query performance problems).
• Experience in monitoring and tuning multiple databases using MS-SQL server Administration tools.
• Competent in performing database consistency checks and planning and scheduling Backup & Recovery.
• Competent in using tools for Monitoring and Tuning of SQL Server Performance.
• Use of DTS, SSIS package for ETL.
• Experience in SQL Server stored procedures, views, configuration of multiple instances.
• Knowledge of Configuring SQL Server Reporting Services (SSRS), SQL Server 2005 Integration Services (SSIS) and Clustering (SQL Server 2000, SQL Server 2005 and SQL Server 2008 R2, SQL Server 2012).
• Excellent experience in setting up Mirroring, Logshipping and working experience in Replication on the production servers in order to make sure that a failover is available in times of the production server failure.
• Knowledge of Always-On Feature.
• The ability to develop, manage and control the DTS / SSIS environment.
• Experience in Migration of Databases / Servers (SQL Server, Oracle) between two corporates.
• Extensive Experience with different phases of project life cycle ERP (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications and giving User Training.)
• Coordinating Troubleshooting and Project Efforts with various teams (Onsite, Offshore, Vendors).
• Supported Microsoft Sharepoint Database on SQL Server 2005/ SQL Server 2008 R2.
• Assisting in evaluating new technology to meet business needs.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation. A quick learner with an aptitude for taking responsibilities and ownership.
• Received the highest rating (Best performer) during the performance review for the Operations team.

TECHNICAL SKILLS

• SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012,
• SQL Server 2008 R2
• SQL Server 2008, SQL Server 2005, SQL Server 2000
• Oracle (10g, 9i, 8i,7), Ms-Access, PostgreSQL 11.1
• Enterprise Manager, Query Analyzer, SQL Profiler, SQL Server Management
• Studio, TOAD for Oracle.
• Actuate Reports 7, Crystal Reports 9.0, Microsoft Reporting Services (SSRS).
• DTS, SSIS, MS-Visio
• Idera SQLSafe, HP Data Protector, EMC Networker for SQL Server,
• Quest LightSpeed. Symantec NetBackup for SQL Server, Veeam
• VBScript, PowerShell
• ASP 3.0
• Windows Server 2012 R2, Windows Server 2008 R2,
• Windows Server 2003/2000, HP-UX, Linux, CentOS 7
• Visual Basic 6.0, Visual Interdev, Business Intelligence Development Studio
• HTML/DHTML
• Maximo (3 Tier Architecture), ERPHeubach (Customized In-houseDeveloped Product).
• Service-Now, BMC Remedy, Infoman, HP Openview, Peregrine
• ServiceCenter, Altiris Ticketing System, ECM Change Management.
• MEGA HOPEX, Orbus iServer, IBM Rational System Architect

PROFESSIONAL EXPERIENCE

Confidential

Solution Platform Architect / Database Administrator

Responsibilities:

• Architect, Design and Implement SQL Server 2014, SQL Server 2016, SQL Server 2017 Farm on the Private Cloud for the Corporate Infrastructure and Different Business Units.
• Single Handedly Managed Project for Consolidation and Virtualization of Physical SQL Servers, to benefit the Infrastructure cost in terms of license of physical VS virtual cores and saved Millions of Dollars for the Organization.
• Managed Project Building Security Servers and Application Upgrade from Windows / SQL 2008 to Windows 2016 / SQL Server 2016.
• Manage, Design and Maintain SQL Server Backup / Restore Policies for the Corporate / Business DB Servers.
• Worked in Enterprise Architect Team and Designed the Taxonomy of various objects in the EA Repository Tool using the TOGAF framework.
• Designed Taxonomy for Application Integrations and Designed the Integration Diagram for all the applications in the Environment.
• Designed Taxonomy and Developed TRM (Technology Reference Model).
• Managed and Maintained the EA Repository Tool as an Admin.
• Collected and Managed License Repository for all the applications in the environment.
• Managed and Maintained AWS RDS and EC2 Database Instances.
• Managed and Maintained Azure Database Instances.
• Served as a CAB Manager under the Enterprise Change Management Team to review changes.
• Maintained and Managed Microsoft AX Dynamics OLTP and DW (Custom Designed) environments.
• Regular Maintenance by applying latest available SQL Server Patches to keep the environment secure.
• Proposed and Implemented Encryption for Financial Critical Data on SQL Server Database.
• Implemented AlwaysOn High Availability Groups for Critical Applications in the Corporate Infrastructure and Business Units.
• Design and Engineer SQL Server Build as a Standard Template for the Corporate DB Servers.
• Architect, Design and Implement DB Solutions to the Business Teams for the Business continuity during the time of Disaster Recovery.
• Perform Disaster Recovery exercises every quarter for all corporate database..
• Design and Implement IT Process and Procedures related to Database and document steps involved in the process.
• Implement Standard Security Policies on the DB Servers to protect the Data visibility / access to unauthorized personnel / segregation of duties.
• Support more than 100+ Database Instances in the SQL Environment (Dev, QA, and Production) on the Private Cloud Infrastructure.
• Managing SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services) Installation / Backups.
• Recommending / Implementing Best Practices related to SQL Server Architecture, Performance, and Configuration.
• Maintenance (Re-indexing, Statistics Update) of all Databases.
• Capacity Planning base on the database growth.
• Initiating new Projects for process automation and self-service offering to the Business Units.
• Adhering to the SLAs and prioritizing the work accordingly related to the severity of the problem.
• Monitoring SQL Server Instances using SCOM, Solarwinds.
• Adhering ITIL best practices and achieve the SLAs for all the customers with appropriate timely response.
• Recommend Infrastructure Solutions related to DB / Applications to Enterprise Architect Team and CIO.
• Provide monthly Reports (Performance / DB Sizing / DB Config) to Sr. Manager IT and CIO.
• Performance tuning of Stored Procedures and recommending to Development Team for better performance of the queries and SQL / OS Resources.
• Developed Security Reports and Performance Dashboards (Reporting Services) for CIO and IT Leaders of each Business Unit.

Confidential

Associate / Senior Database Administrator (SQL Server)

Responsibilities:

• Managing and Supporting SQL Server DBA activities / operations.
• Active Senior Support Team Member in the DBA Team.
• Resolve Priority P1, P2, and P3 issues assigned to the Team.
• Performance troubleshooting related to CPU, Memory, blocking, deadlocks.
• Supporting 10,000+ databases in the environment.
• Supporting Multiple Nodes Cluster Setup.
• Recommending Best Practices related to SQL Server Architecture, Performance, Configuration.
• Recommending long term solutions for Chronic Issues.
• Initiating new Projects for process automation and self-service offering to various end Users.
• Capacity Planning base on the database growth.
• Supporting Multi TB Databases.
• Maintenance (Re-indexing, Statistics Update) of all Databases including Multi-TB size databases.
• Supporting Multiple Mirroring, Logshipping, Replication, Snapshots Setup.
• Managing SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services) Installation.
• Experience in working on Root Cause Analysis for Chronic Issues and giving a long term resolution to minimize the priority tickets.
• Putting Scheduled Jobs on Ice using CA Automation Tools (Autosys) and fixing the Scheduled Job issues to prevent multiple failures of critical Support Jobs.
• Adhering to the policies and procedures laid by the DB Management Team.
• Communicating with Multiple end users for resolving and troubleshooting their issues and the tickets raised by their team.
• Implement and understanding Environment Changes.
• Adhering to the SLAs and prioritizing the work accordingly related to the severity of the problem.
• Support the Backup and Restore activities related to DB.
• Assist in Supporting the Storage and Disk Management on the SQL Servers.
• Monitoring SQL Server Instances using Geneos Console.

Confidential

Lead Database Admin (Microsoft SQL Server) / Database Migration Specialist

Responsibilities:

• Managing and mentoring a team of 8 DBA supporting SQL Server instances (Technical Team Lead).
• Configured and designed n + 1 SQL Server cluster setup for shared Production environment.
• Build and configured SQL Server 2012 active + passive cluster environment.
• Support the SQL Environment on the Cloud Infrastructure.
• Managing multiple Technical projects, guiding the team and delivering the projects at the defined timelines.
• DBA Service Transition from an existing support Company to BMC and training BMC DBA team.
• Aligning DBA resources for a 24 x 7 support.
• Migrated 600+ databases to new datacenter in less than 40 days..
• Supporting around 90+ live customers in an OnDemand operating Environment.
• Designing and publishing various process and procedures for the regular DBA activities.
• Guiding and training the team to follow proper process and procedures.
• Ticket Queue Management.
• Provide 24 x 7 support for any Emergency Calls.
• Communicating with Sr. Managers, Director, Executives in the Organization.
• Communication with customers for any issues reported and resolve them on priority.
• Single point of contact for any Database Administration request.
• Designed Service Catalog for the Database Team.
• Enabled Encryption on Customer Databases.
• Managing Minimum downtime for the customers during the maintenance window.
• Planning and layout of activities to be executed by the DB team for any maintenance tasks involved.
• Adhering ITIL best practices and achieve the SLAs for all the customers with appropriate timely response.
• Setup Mirroring between two datacenters for DR testing as a service offering to the customer.
• Setup Always-On Capability for DB on the DR Instance for High Availability.
• Setup a process to Create DB Snapshot over the mirrored Databases to suffice the reporting capabilities of the Production Database.
• Setup Audit Specifications for Audit Review by the Information Security Team.
• Securing the Databases with appropriate access to the customers.
• Designing Backup / Restore policy and procedure.
• Designed ODBC connectivity for the customers to connect the Databases.
• Designed Decommissioning process.
• Designed FTP process.
• Part of the team in designing Change Management Policy.
• Documenting the environment for FISMA Compliance certification.
• Weekly review of Storage Capacity on the SQL Servers.
• Monthly review of the Access granted on the SQL servers.
• Help Reporting Manager in providing individual reviews of the team members for performance appraisal.