SUMMARY:

• I have over 11 years of Operations experience executing engagements like Database Administration, Tier 3 production Support, System Admin, Release PM and Technical Lead in Confidential technologies in varied domains, and good understanding of all stages of the Software Development Life Cycle (SDLC) and Agile Process.
• Good Technical Hands on experience in Database System and Application administration. Design of Server Architecture for High availability of business critical applications. Good hands on experience with ITIL and MOF process within Confidential .
• Good IT experience in Database Administration and Support of MS SQL Server 2016/2014/2008 R2/2005 in Production, Test, Development and Cluster Server Environments.
• Have good Hands on administration of BI Apps/ database/application/reporting solutions of Confidential business critical systems for over 11 years.
• Migration of Applications / Sql servers from On - Prem servers to Azure environment.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2012 and previous versions.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer
• Migration experience from MS SQL Server 2005 to MS SQL Server 2008 and 2012.
• Powershell scripting tools created for Day to Day tasks like Server/Services Offline/Online, Server drive space details etc.
• Good Knowledge on SQL server 2014 Always on.
• AWS experience (Within RDS and EC2).
• 11 + Confidential years’ experience in varied domain, technologies, teams.

TECHNICAL SKILLS:

Technologies: .NET Framework 4.5/4.0, ASP.NET, ADO.NET, ASP 3.0Web Services, Mirroring, Clustering, ETL, SSIS, DTS

Databases / RDBMS: MS SQL Server 2016 and previous versions, Sybase SQL Server, Oracle 8i

Operating Systems / Platforms: Win 2012 Adv Server and most of previous versions

Application / Web Servers: IIS 8.5 and most previous versions.

Tools: Getsmart, wherescape, Jenkins, Nagios, Octopus, Jira, Confluence, SAN, myvip, RDTracker, MS Project, MS Visio, Product Studio, MS VSTF, Source Depot, MS Office.

Programming Languages: T-SQL, Power Shell

PROFESSIONAL EXPERIENCE:

Confidential

DBA \ Application Support Engineer

Environment: Windows Server 2012, MS-SQL 2016, MS Office suite, Nagios, SCOM,Jenkins,Jira,Getsmart,confluence.

Responsibilities:

• Incident Management and problem management
• Proficiency in troubleshooting issues related to network/Server/Database and application.
• Achieved a 98% SLA to customer response incidents
• Document and process server procurement, work with SAN team for drive configuration and troubleshooting issues.
• Use of powershell scripts to perform routine tasks
• Maintained a high level of customer satisfaction
• Provide updates to management of known risks and issues for visibility.
• Installation and configuration of database servers and application tools
• Providing deployment using Jenkins and support to Test / Preproduction and Production environment. Setting up systems for the above from procurement planning to Go-Live.
• Developed release to production implementation plans for complex implementations
• Publish Tableau Dashboards
• Migration of SSIS Packages.
• Use Getsmart to rotate servers out of load balancers.

Confidential

DBA \ Application Support Engineer

Environment: Windows Server 2012, MS-SQL 2014, MS Office suite, Azure Cloud.

Responsibilities:

• Proficiency in troubleshooting issues related to network/Server/Database and application.
• Familiar with deployment processes for cloud services such as Azure and work flow based tools.
• Deploying builds for MSSTARR applications.
• Work on Mirroring, Clustering and High Availability environments.
• Onboarding On - Perm systems to Azure Cloud environment.
• Troubleshooting performance bottlenecks in Azure environment and configuring the systems.
• Monitored and modified Performance using execution plans and Index tuning. Ensured the packaging/processing deliverables are completed on time.
• Automation in monitoring servers and databases.
• Installing and upgrading SQL servers as and when new versions/patches are made available.
• Raising tickets for new Azure VM’s and working with Azure team to meet deadlines. On boarded 12 applications to Azure environment saving Confidential cost and time.
• Prepare Confidential and work towards implementing best approach to prevent repeat issues.
• Ability to interact with different Business Groups and track progress of Critical issues.
• Document and process server procurement, work with SAN team for drive configuration and troubleshooting issues.
• Use of powershell scripts to perform routine tasks
• Provide updates to management of known risks and issues for visibility.
• Maintain latest project related documents/KB articles into sharepoint.
• Incident Management and problem management
• Technical /Code specifications review for risk mitigation.

Confidential

DBA \ Application Support Engineer

Environment: Windows Server 2008 R2, MS-SQL 2008 R2, MS Analysis Server 2008 R2, Visual Studio 2012.

Responsibilities:

• Onboarding of servers, Planning related to requirement and budget for infra related tasks.
• Analytical - Problem Solving Skills.
• Troubleshooting complex application and infra related issues.
• Support and co-ordinate between multiple teams for resolution of issues.
• Providing support to Test / Preproduction and Production environment. Setting up systems for the above from procurement planning to Go-Live.
• Handle issues related to Server/Database and Network. Co-ordinate with teams for timely intervention and unblock issues as needed.
• Provide on-call support 24/7.
• Deploying releases after code review.
• Maintain documents and provide status update during issues/releases to management team.
• Setting up Test/Pre-prod/Prod environments .
• Work with business to accommodate maintenance window with minimal downtime due to application criticality
• Fix production issues on the spot due to criticality of the application.
• Represented production team in triage, design and functional spec meetings
• Maintaining security for the applications.

Confidential

DBA \ Application Support Engineer

Environment: Windows Server 2008 R2, MS-SQL 2008 R2, MS Analysis Server 2008 R2, Octopus, SCOM 2012

Responsibilities:

• Deployment of Code to UAT and Prod environments using Octopus tool.
• Installation and configuration of database servers and application tools
• Support Cube processing to Worldwide users within SLA.
• Co-ordinate with engineering team and provide inputs.
• Analytical - Problem Solving Skills.
• Good experience at Excel pivoting and power pivoting.
• Validate the data exposed through OLAP Cubes. This included verifying and validating the data in the Facts and Dimension tables.
• Drive documentation for processes and improvements to streamline and optimize work performed.
• Installing SQL/OS Hot fixes and security patches Clustered servers.
• Cluster failovers and managing HLB through myvip to disable and enable servers.
• Setting up of Mirroring,Logshipping for Databases for High availability.
• Report generations weekly/daily/monthly.

Confidential

DBA \ Application Support Engineer

Environment: Windows 2008 Enterprise, MS-SQL 2008, MS Analysis Server 2008, Windows Adv 2003, MS-SQL Server 2005

Responsibilities:

• Installation and configuration of database servers and application tools
• Creation and setting up user groups and permissions.
• Troubleshooting complex user related issues.
• Monitoring and optimizing the performance of the server
• Allocating system storage and planning future storage requirements for the database system.
• Installing SQL/OS Hot fixes and security patches. Including Logshipping and Clustered servers.
• Interact on a need basis with QA teams and development teams to design and deploy each new generation of our computing and network architecture.
• SAN Drive documentation for processes and improvements to streamline and optimize work performed.
• Manage and implement Backup and Database recovery effectively
• Windows 2008 Clustering failover
• Trouble shoot SAN drive issues.
• Setting up SCOM alerts.

Confidential

DBA \ Application Support Engineer

Environment: Windows Adv 2003, MS-SQL Server 2005,Siebel 7.7.3

Responsibilities:

• Work directly with customers to understand their IT infrastructure and help build server configurations that support optimal performance of our solutions.
• Upgrade and maintain Production and UAT environment.
• Work directly with testers and developers to provide timely resolution to production issues.
• Provide direction to improve, analyze, and optimize day-to-day operations in a very large automated infrastructure of Windows servers
• Provide technical expertise to perform root cause analysis of service interrupting incidents; develop and implement strategies to prevent recurrence
• Interact on a need basis with QA teams and development teams to design and deploy each new generation of our computing and network architecture.
• Create or propose technical solutions when faced with a new complex systems design or process issue, where little or no precedent exists.
• Drive documentation for processes and improvements to streamline and optimize work performed.
• Keep up to date inventory of all Server equipments.

Confidential

DBA \ Application Support Engineer

Environment: Windows Adv 2000, Windows Adv 2003, MS-SQL Server 2005,Siebel 6.6,Siebel 7.2,Siebel Analytics

Responsibilities:

• Work closely with other global support team to have smooth functioning and rollout of assigned tasks. Timely Escalation of issues and follow up with Redmond team and MS India. Responsible for any issues related to the offshore project.
• Operational responsibilities include all of the tasks which keep the servers up and running on a daily basis such as installing/upgrading SQL, Monitoring Server errors and troubleshooting them, configuring backups and DBCCs, Working on ad hoc requests, coordinating maintenance work with other operations group, performing maintenance in off-hours, monitoring log shipping, installing SQL, Hot fixes. Project Documentation, Installing and configuration of SQL Server Installing and configuring Siebel 7.5 Backup of the Siebel test environment. Restoring the Databases after every Phase of testing.
• Supporting offshore team on Siebel and SQL server Handling requests on SQL logins Requests on Database access and privileges Handling requests on the SSIS packages Configuration of Siebel environment setting up Siebel gateway, Enterprise servers.
• Generating, Managing reports through SSRS
• Trouble shooting the Siebel administration issues Upgrading the Siebel Database using Siebel configuration Importing and exporting the Siebel repositories Synchronizing the Database schema using Siebel Configuration Siebel Application administration