WA Database Administrator Resume

PROFILE

PROFESSIONAL EXPERIENCE

Confidential

WA Database Administrator

Responsibilities:

Working on alwaysOn, Azure ADF, powershell automation and planned maintenance tasks.
Providing Azure support, on - prem db’s to IaaS migration, Cosmos regional failovers and data migrations.
Collaboration with infrastructure teams for decommissioning, patching, maintenance and troubleshooting.
Assisted with TLS security enforcement with coordinated smoke tests among payment replication systems.
Added automation database solution to support data convergence analytics.
Modeled data, built and deployed PowerBI reports to visualize and asses incident management tickets.
Monitoring and troubleshooting reliability for integrated token services for mission critical payment systems.

Environment: SQL Server AlwaysOn, OLTP NoSQL, Replication, PowerBI, Azure, DevOps, Cosmos, Commvault.

Confidential

Database Administrator

Responsibilities:

Follow-up ServiceNow ITIL based requests, incidents, cutover changes, monitoring and calls.
Setup Replication, Linked Servers, performance tuning on SQL Server environment
Worked closely with developers to identify slow performing queries and tune them by improving design patterns and provide index tuning.
Handle Admin tasks on Informatica, SSRS Reports and SSAS cubes, security segregation duties.
Verify cluster server’s availability and troubleshoot failures related to infrastructure and storage team issues.
Attended Change Management and SOT Calls to collaborate with other IT team areas during critical production incidents.

Environment: SQL Server 2005-2017, Windows Server 2008, 2016, Idera Litespeed, Informatica.Confidential

Database Administrator

Installation and configuration, Database monitoring, establish performance baselines for servers
Assist on production releases and server Load testing.
Perform database backups and database refreshes, review and execute changes.
Aided the design of an isolation level change to eliminate contention in a critical production database.
Implement automation database maintenance tasks using PowerShell and SSIS
Perform database growth capacity planning

Confidential

Database Administrator

Responsibilities:

Monitoring databases, evaluating upcoming alerts, engaging Application support or Infrastructure teams.
Collaborated with Development and Application teams to implement QA and Production Releases
Assistance to Maintenance and Disaster Recovery drill windows collaborating with infrastructure teams.
Provide Database access and account permissions through controlled workflows.
Elaborate on incidents or report findings of database or infrastructure related issues.
Worked with Windows Admin team to perform controlled service resets and operating system related issues
Conduct code reviews of TSQL scripts; create traces for troubleshooting performance issues.
Perform health checks on database services and availability during server patch maintenance windows

Environment: SQL Server 2000-2012, Windows Server 2003, 2008, Lite speed, Citrix,VmwareSofttek - Client:McKesson

Confidential

Database Administrator

Responsibilities:

Hands on daily database monitoring, evaluate alerts and maintenance checklist
Perform standard database operations including exports, imports, table restorations
Provided resolutions and RCA of upcoming incidents under 24x7 support duties and incident management.
Contacted Server infrastructure teams and Storage teams for assistance or escalations
Implementation of SQL Server virtual workstation environment
Wrote SOPs to collaborate, standardize tasks for best practices with DBA Team.

Environment: SQL Server 2000, 2005 2008, SSIS, Reporting Services, Litespeed, VMWare.Softtek - GE Commercial Finance

Confidential,

Application Support

Responsibilities:

Application support to calling agents and business application owners.
Coordinated Application Control changes and collaborated with different IT teams to resolve issues
Implemented data transformation scripts (ETL) in sql server for gathering Fleet accounts from application database and map the formatted data into a server folder to be used by an external application.
Used SSIS tools to import vehicle account information into the application database from external business sources.
Guided Business intelligence team to answer questions related to the use of the application's data warehouse.
Worked with vendor on new requirements and analysis for application enhancement changes.
Communicated technical issues to different Vendors and inquired effort-estimation requirements