We provide IT Staff Augmentation Services!

Database Administrator Resume

Bellevue, WA

PROFESSIONAL SUMMARY:

  • Over 9+ years of IT experience in Database Administration and Support of MS SQL Server 2012/2008R2/2005 in Production, Test, Development and Cluster Server Environments.
  • Experience in implementing high availability using Server clustering (Active - Active, Active-Passive) in Windows 2008/2012 environment.
  • Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012 .
  • Experience in Disaster Recovery Planning, Execution and Testing at remote side.
  • 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.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
  • Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration, data compression and synchronization.
  • Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
  • Extensive experience with IIS (Internet Information Services) and HLB.
  • Extensive experience in Capacity Management and assigning storage for cloning and non-cloning environment
  • Extensive experience in setting up Cloning environment and troubleshooting issues.
  • Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008/2012.
  • Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
  • Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
  • Solid experience in ETL tools METAL and Informatica.
  • Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
  • Hands on experience in Metal 3.1 and Informatica 9.0/9.1 a data warehouse tools used in EDW for the ETL flows
  • Good Knowledge on SQL server 2012 Always on.

TECHNICAL SKILLS:

Technologies: Cloning, Mirroring,Clustering, Web Services, ETL, SSIS,SSRS,SSAS, Siebel 7.7, Informatica, Metal, Singularity

Databases / RDBMS: MS SQL Server 2005/2008/2012 , Sybase SQL Server

Operating Systems / Platforms: Windows, COSMOS

Tools: RD Tracker, MS Project 2005, MS Visio 2010, Product Studio, MS VSTF, Source Depot, SQL IDERA

Programming Languages: T-SQL, PowerBuilder, SQL*Plus, power shell, VB Script, C#,SCOPE

ETL tools: Metal and Informatica 9.1

Load testing tools: SQLQueryStress, SQL Load Generator

Web Technologies: IIS, XML

Reporting Tools: MSRA, Power Pivot, Power BI

EXPERIENCE DETAILS:

Confidential, Bellevue, WA

Database Administrator

Environment: Windows 2012, MS-SQL Server

Responsibilities:

  • Planning and Migrating servers in datacenters
  • Managing Remedy tickets and resolving issues in time.
  • Deploying builds from Coinstar and Redbox application
  • Work on Mirroring, Clustering and High Availability environments
  • Reviewing the codes prior to production deployment.
  • Setting up SQL Idera for backups and monitoring purpose.
  • Deploying scripts production environment.
  • Planning of 2014 upgrade for the Coin environment.
  • Managing ETL process for the entire application.
  • Setting up and deploying in Azure environment.
  • Installing and upgrading servers in Coin environment.
  • Setting up and monitoring servers through SQL Idera tools.
  • Performance management of the application.
  • Trouble shooting various application related issues.
  • Planning/setting up backup strategy.

Confidential, Bellevue, WA

Incident Management /Problem Management

Environment: Windows 2012, MS-SQL Server 2012, SQL Idera, Azure

Responsibilities:

  • Improving the system for all Sales applications
  • Reviewing KB articles/Operations guide.
  • Process implementation for L1/L2/L3.
  • Work on the gaps across the teams and provide solution.
  • Drive KB articles and problem management tickets.
  • Drive any gaps in providing solution to the users.
  • Provide metrics to Lead Management team.
  • Reduce the number of tickets in the system by driving the team to create VSTF and KB articles.
  • Creating reports for improving the process like unassigned tickets /Aging tickets/Escalation timeline etc.
  • Handling escalations in all the portfolios of Confidential Sales applications.

Confidential, Bellevue, WA

SQL SERVER DBA

Environment: Windows 2012, MS-SQL Server 2012

Responsibilities:

  • Performance tuning, data profiling in a clustering environment.
  • Provide optimization recommendations to the team and get the changes implemented.
  • GIT for source code control.
  • Working on tuning workflow items.
  • Code review prior to deployment to verify check points and performance.
  • Tuning Explicit XML queries.
  • Monitoring deployment on DCAdmin and correcting issues in the servers
  • Setting up Application with health check monitors .

Confidential, Redmond, WA

SQL DBA /Module Lead

Environment: Windows Adv 2003,Windows 2008, Windows 2012, MS-SQL Server 2008/2012

Responsibilities:

  • Technical /Code specifications review for risk mitigation.
  • Implementing high availability using Server clustering (Active-Active, Active-Passive).
  • Setting up HLB for IIS servers for load balancing using Active - Active clustering.
  • Migrating applications to Azure environment.
  • Implementing alerting systems for the applications
  • Creating customized monitoring tool using PowerShell scripts.
  • Planning storage for the applications
  • Used SSIS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
  • Managed the use of disk space, memory and connections.
  • Incident Management and problem management
  • Performed DBCC utilities and fixed data corruption in application database
  • Monitored and modified Performance using execution plans and Index tuning. Ensured the packaging/processing deliverables are completed on time.
  • Represented production team in triage, design and functional spec meetings
  • Setting up mount points and cloning for Large DB’s
  • Dogfooding SQL server katmai and Windows 2008
  • Automation in monitoring servers and databases
  • Installing and upgrading SQL server katmai RTM
  • Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
  • Controlled user access rights, and managed data security.
  • Traced long running queries and deadlocks using SQL Profiler. Setting up Mirroring for dB metal and dbedwmetadata Databases.
  • Perform Fail over/Fail back in EDW environment
  • Setting up cloning & mount points for the application
  • Maintaining security for the applications.
  • Trouble shooting the Job using METAL
  • Upgrading SQL server katmai to CTP5,CTP6,RTM
  • Implementing Best practices in the applications portfolios Setting up and monitoring SSAS
  • Checking Database Health by using DBCC Commands and DMVS
  • Upgrading SQL server 2012 CU4
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications .
  • Setting up environments with cloning infrastructure and troubleshooting
  • Work with PSS SQL Product team during/after the dogfooding period and raise issues in the product
  • Deploying complex builds
  • 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.
  • Implement data compression for databases
  • Handling offshore team and resolve the technical issues escalated.
  • Identifying Risks in the project proactively.
  • Setting up singularity in EDW project.
  • Communicate status, risks and issues to Dev/product and test teams.
  • Maintain SLA and quality for each release.

Confidential, Sammamish, WA

Service Engineer

Operating System(s): Windows 2003 Adv Server

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

Responsibilities:

  • Risk mitigation and analysis/implementation.
  • Communicate status, risks and issues to Dev/product and test teams.
  • Reviewing release notes with the build/Dev and test teams. understand risks or issues that might hinder the build when released to product team with DEV/Test/Product.
  • Understanding content, risks, and trade-offs in the builds released by dev and their impact.
  • Maintain SLA and quality for each release.
  • Tracking issues that come across during the build through product studio.
  • Following up on all breaks and resolved in a timely fashion. ensured the packaging/processing deliverables are completed on time.
  • Represented production team in triage, design and functional spec meetings
  • Putting tools and processes in place to ensure that build quality is not compromised.
  • Providing the QA coverage to all the build tools.
  • Installing and configuration of SQL Server.
  • Installing and configuring SQL server reporting services
  • Maintaining security for the applications.
  • Handling requests on the DTS packages.
  • Setting up Siebel gateway, Enterprise servers.
  • Trouble shooting the Job related, SQL administration, SSRS and IIS related issues.
  • Upgrading SQL 2000 to Yukon (SQL 2005)
  • Replicating the environments
  • Processing Dev Code for deployment/release.
  • Responsible for deploying and Dev code to UAT and production environments.
  • Installing IIS and configuring websites.

Confidential, Bellevue, WA

Build Engineer /Siebel Administrator

Operating System(s): Windows 2000,Windows 2003 Server

SKILL: MS SQL Server, PL/SQL, Siebel 6.0 & Siebel 7.7

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

Responsibilities:

  • Risk mitigation and analysis/implementation.
  • Build Support for Dev teams to triage build issues.
  • Communicate status, risks and issues to Dev/product and test teams.
  • Create schedules for applying builds and refreshing the environment with the production backups.
  • Documenting release notes for all the builds and base build notes which are used for building environment for test and dev team. Documenting the procedures clearly so it is easier for the product teams to apply on their environment when released.
  • Scheduling release notes review meetings to understand risks or issues that might hinder the build when released to product team with DEV/Test/Product.
  • Understanding content, risks, and trade-offs in the builds released by dev and their impact .
  • Maintain SLA and quality for each releases .
  • Consult production team to understand the risks before any release.
  • Tracking issues that come across during the build through product studio.
  • Automate the build procedure to make things simpler.
  • Following up on all breaks and resolved in a timely fashion. ensured the packaging/processing deliverables are completed on time.
  • Represented build team in various meetings like ship room and other project status/bug triage meetings.
  • Putting tools and processes in place to ensure that build quality is not compromised.
  • Providing the QA coverage to all the build tools.
  • Managing the source code control aspects of windows releases.
  • Installing and configuration of SQL Server.
  • Installing and configuring Siebel 7.5.2
  • Applying the development code to test environment .
  • Restoring the Databases after every Phase of testing.
  • Support for offshore team on Siebel and SQL server
  • Handling requests on SQL logins.
  • Requests on Database access and privileges.
  • Handling requests on the DTS packages.
  • Configuration of Siebel environment.
  • Setting up Siebel gateway, Enterprise servers.
  • Trouble shooting the Job related, Siebel administration and IIS related issues.
  • Upgrading the Siebel Database using Siebel configuration tools
  • Upgrading SQL 2000 to Yukon (SQL 2005)

Hire Now