LiveCareer
LiveCareer
  • Dashboard
  • Jobs
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Education
      • Administrative
      • Medical
      • Human Resources
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Nursing
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • View All
    • Resume Services
    • Resume Formats
    • Resume Review
    • How to Write a Resume
    • CV Examples
    • CV Formats
    • CV Templates
    • Resume Objectives
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • Business Operations
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Jobs
    • Mobile App
    • Job Search
    • Job Apply Tool
    • Salary Calculator
    • Business Letters
    • Job Descriptions
  • Questions
  • Resources
  • About
  • Contact
  • 0Notifications
    • Notifications

      0 New
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Sr. SQL Server DBA
Please provide a type of job or location to search!
SEARCH

Sr. SQL Server DBA Resume Example

Resume Score: 50%

Love this resume?Build Your Own Now
SR. SQL SERVER DBA
Professional Summary
Senior Database Administrator/ Developer with over 9 years of experience in mission critical operations, system administration and database engineering. Experience leading global programs and teams on both operational and strategic level. Proven decade long successful experience of implementing and guaranteeing SLA for mission critical and large data platform for Xbox, Exchange Online and Microsoft.com. SPECIALITIES SQL Server Software Architecture, Design, Best Practices and troubleshooting SQL Server and T-SQL: Performance analysis and delivering actionable insights Benchmarking SQL Server implementation with TPC-DS, TPC-H, TPC-C. OLTP: Architect, Design, Implement, and Optimize Automation of administrative and operational processes through PowerShell and TSQL Review existing processes and drive changes or institute new processes as necessary, including the areas of monitoring, upgrades, and tuning Generate high-quality project documentation, such as architecture designs, implementation plans, design documents etc. Provide technical escalation and be on call via pager during designated periods Recommend, own and drive application changes to improve application performance Design, implement, function test and load test packages, stored procedures, triggers and other database objects to support new and existing applications Develop, enforce and maintain appropriate database change control procedures for the database objects Develop and maintain expert-level knowledge in SQL Server internals and best practices for database architecture and physical data modeling SQL Server Database Administration on multi-terabyte production databases C# Code debugging Database Migration and consolidation maintaining SLA Designing and implementing Disaster Recovery solution Implementing SQL Server security best practices Proven proficiency in maintaining strict SLA / supporting /troubleshooting for large scale enterprise level highly available RDBMS system Designing /implementing / supporting SQL Server Storage Working knowledge on MongoDB and Oracle. TECHNICAL SKILLS 10 years of DBA experience designing and administering multiple Microsoft SQL Server databases in a 24/7 mission critical environment. 4 Years database development using TSQL procedures, functions, views. Strong knowledge of T-SQL, Stored Procedures, Functions, views and other objects. Creating/ Designing and Implementing ETL packages using SSIS. Ability to data mine and develop reports using a variety of reporting software packages with a high aptitude for learning new reporting software packages. Deep understanding of source code control and versioning methodologies, such as Team Foundation Server and Product studio. Good understanding of various TPC benchmarking standards/tools.
Skills
Work History
Sr. SQL Server DBA, 03/2016 to Current
BCI – Bellevue
  • SQL Server Always ON Solution, Replication, Mirroring, Log shipping, Windows and SQL Server Failover Clustering, Windows NLB Working knowledge on SQL Server Integration Service, SQL Server Analysis Service, SQL Server Reporting Service Windows Server 2012, SQL Server 2012 / 2014 / 2016 RTM Working knowledge on System Center Operations Manager Familiarity with ITIL processes and ER diagram, SYSINTERNALS, WINDBG and several others performance tuning and test tools Stay current with technology trends and developments in the industry and participate in service development.

Service Engineer, 10/2012 to 04/2014
  • 2, Exchange Online Protection, Microsoft Take ownership to automate backup / Index and other maintenance DB scripts to deploy on 200+ SQL servers running on SQL Server 2008R2 /Widows 2008.
  • TSQL Code review and Performance tuning.
  • Design /Implement SQL Server 2012 DR solutions.
  • Participating in 24/7 on call rotation.
  • Taking ownership and Collaborating with HP and different teams to plan and successfully execute time sensitive project maintaining strict SLA: Replace HP Adaptec Controller on 101 production servers running on Windows Server 2008 and SQL Server 2008 R2 maintaining SLA Review and improve/automate SQL Server /Windows monitoring Updating/ debugging existing PowerShell and C# scripts to manage the big infrastructure.
  • Designing and Developing backend table schema, creating and implementing Stored procedure/Views etc.
  • Supporting/ Managing/ Capacity Planning/ Improving monitoring /Automating tasks for Exchange Online Protection backend infrastructure running on SQL Server 2008 R2 and Web store, maintaining SLA for uptime Testing /Implementing SQL Server 2012 Always On and other features in test and Production.
  • Taking part in TSQL and PowerShell code review/ debugging.
  • Reviewing/Improving and implementing SQL Server Security best practices Writing design spec/ TSQL script for SQL maintenance tasks, working with development team to implement it Working with monitoring team to help improve/ update SQL and overall environment monitoring Driving and accomplishing the project to replace Adaptec controllers on 100 DB servers maintaining SLA Troubleshooting Web store / SQL Server and DB issue Participating in C# and other training by Microsoft Engineering Excellence Participating in security training Mentoring team members.
SQL BI Developer /Sr. SQL Server DBA(V, 05/2012 to 10/2012
  • Microsoft Retail Group, Microsoft TSQL Code performance tuning and review, preparing performance Metrix using SSRS.
  • Implementing TPC-C and TPC-DS benchmark.
  • Design , Create and Implement ETL packages using SSIS.
  • Design and Implement SSRS reports.
  • Designing and implementing backend objects.
  • TSQL performance tuning.
  • Taking ownership of backend infrastructure and providing operational support.
  • Troubleshooting retail CMDB, SCOM OLAP test and production on SQL Server 2008 R2 and SQL Server 2012 environment including VMs.
  • Planning /implementing Retail OLTP physical and logical database.
  • Designing/implementing database object schema based on business needs.
  • Meeting SLA and implementing SQL Server 2008 DR strategies SQL Server failover clustering on VMS/Replication for production environment running SQL Server 2008 R2.
  • Implementing /Managing /Supporting and troubleshooting Windows/SQL Server 2008 R2 clustering environment.
  • Proactive capacity planning for SCOM and CMDB database.
  • Taking ownership and provide solution for SQL Server OLTP performance methodology.
  • Implementing SQL configuration and security best practices.
  • Automate SQL admin tasks using TSQL, upgrading SQL Server environment.
  • Auditing and Documenting all environments, processes and storage best practices.
Sr. SQL Server DBA/ DEV, 09/2011 to 05/2012
  • Taking ownership of SQL Server OLTP test and production SQL Server 2005 / 2008 R2 environment Design, document and create monitoring tool replacing existing monitoring system to reduce / minimize monitoring cost Meeting SLA and designing/ implementing/ creating / testing SQL Server 2005/ 2008 DR strategies including backup/ restore, Mirroring, Log Shipping and Failover Clustering for production environment running SQL Server 2008 R2 and SQL Server 2005.
  • Supporting and troubleshooting Windows/SQL Server 2008 R2 clustering environment Planning downtime and patching all production SQL Servers.
  • Capacity planning and guiding system admin for the appropriate storage and RAID LEVEL for SQL Server and SQL Server Clustering environment.
  • Troubleshooting any SQL Server related issues, work with MS CSS team to resolve SQL crash issues in production.
  • Create ad hoc SSIS packages to migrate and transform retail data.
  • Designing and implementing multi-site clustering environment in 2008 R2.
  • TSQL Code review, code and server performance tuning.
  • Re design and implementing / automating SQL Server monitoring processes.
  • Implementing SQL configuration and security best practices.
  • Automate SQL admin tasks using TSQL, upgrading SQL Server environment.
  • Upgrading SSRS reports and SQL Server database engine to 2008 r2 Auditing and Documenting all environments, processes and storage best practices.
BI developer / DBA, 01/2011 to 09/2011
  • V-), Microsoft Exchange Online Services, Microsoft Develop/ Deploy / Update/ Troubleshoot SSRS report, TSQL code and SSIS packages.
  • Planning / implementing different SSRS reports out of SCOM DW for monitoring.
  • Generating SSRS report out of TFS data Build Crystal Reports as required.
  • Working with program managers to gather data points for SSRS report development.
  • Planning /Migrating existing SharePoint and Excel based reports to SSRS platform.
  • Writing TSQL code, design indexing, test and tune all the codes for optimized performance.
  • Secure/ Administer SSRS lab servers.
  • Automate SQL admin tasks using TSQL, upgrading SQL Server environment.
  • Upgrading SSRS reports and SQL Server database engine to 2008 r2 Auditing and Documenting all environments, processes and storage best practices.
09/2010 to 01/2011
  • SQL Server DBA, (V-)Microsoft XBOX Live Services, Microsoft TSQL and batch scripting to automate SQL admin tasks.
  • Performing logical and physical data modeling.
  • Supporting/patching large production environment; implementing and troubleshooting database mirroring, replication, web store, taking part in database modeling and documentation.
  • Work as a release engineer.
  • Investigating and troubleshooting SQL Server performance issues.
  • Troubleshooting SQL Server related issues filed as bugs in product studio, implement RFCS.
  • Review TSQL code and help product group optimizing TSQL applications for best performance.
  • Received training at XOC on escalation process and Xbox environment as a whole.
08/2006 to 06/2010
  • SQL Server DBA, (V-)MSCOM, Microsoft Supporting Microsoft.com and Learning.microsoft.com global customers Diagnose/troubleshoot/ configure SQL server Replication, Mirroring, Log Shipping, NLB, Clustering, H/W clustering or any other database related issues escalated by tier 2, tier 1 team 24/7 basis to meet the requirement of SLA.
  • Working with networking and web system engineer closely to resolve any application, server or network related issues as and when required.
  • Planning and implementing disaster recovery solutions.
  • Implementing additional monitoring system to meet SLA.
  • Building.
  • Configuring new servers with Windows 2008 R2, SQL Server 2008, Reporting Server 2008 RTM, SQL Server 2008 R2.
  • Communicating with customer; planning and migrating SQL 2000, SQL 2005 databases to Windows 2008R2/SQL 2008 environment as part of TAP commitment: ensuring to meet SLA during the migration.
  • Troubleshooting any post migration issue.
  • Administering, troubleshooting issues running reporting servers 2008 RTM.
  • Troubleshooting customer issues for backend application hosted on MSCOM production environment, taking part in customer's architecture review and evaluates them from backend perspective.
  • Educating and guiding MSCOM customers to tune TSQL code, introduce best practices and to get started with new Database application etc.
  • Migrating SQL server 2000 and SQL server 2005 SSRS environments to SQL 2008 SSRS.
  • Administering, configuring and troubleshooting server instances participating in transactional and transactional peer to peer replication or Mirroring principal in transactional replication.
  • Supporting windows network load balancing for availability of database servers.
  • Administering, configuring and troubleshooting servers with databases in mirroring.
  • Troubleshooting, reviewing and tuning TSQL code.
  • Configuring, troubleshooting log shipping.
  • Planning and executing solutions based on customer requests.
06/2005 to 10/2005
SQL Server DBA – Electric
  • Taking ownership of automate routine administrative process.
  • Tuning/reviewing TSQL queries and store procedure.
  • Troubleshooting and analyzing deadlock on different production server.
  • Designed database schema with Entities, Attributes, and Relationships.
  • Designing, Creating, Monitoring SQL agent jobs and troubleshooting SQL Server job errors on production.
  • Helping Development team to create efficient Queries, Indexes, Views, and Stored Procedures Designing, Configuring and Administering security on SQL Server Designing/Testing DR processes to minimize downtime and data loss.
  • Configuring, Designing Log shipping and testing existing log shipping process in place.
  • Implementing/testing failover clustering in SQL Server on production servers.
  • Implementing table fragmentation, disk I/O report using SQL Server 2000 reporting services.
  • Analyzing the impact of Service pack on different production servers running Siebel and implementing service pack on those servers accordingly.
  • Executing SQL Server requests on day to day basis sent by clients in different environment.
  • Handling and troubleshooting client's requests/issues on day to day basis.
Education
Bachelor's Degree: Economics, University of Calcutta -
Economics
Diploma: Computer Application and Object Oriented Languages, NIIT
Computer Application and Object Oriented Languages
Microsoft Certified Database Administrator:
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • BCI
  • SQL Server DBA

School Attended

  • University of Calcutta

Job Titles Held:

  • Sr. SQL Server DBA
  • Service Engineer
  • SQL BI Developer /Sr. SQL Server DBA(V
  • Sr. SQL Server DBA/ DEV
  • BI developer / DBA

Degrees

  • Bachelor's Degree : Economics ,
    Diploma : Computer Application and Object Oriented Languages ,
    Microsoft Certified Database Administrator :

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Sr.-SQL-Server-DBA-resume-sample

Sr. SQL Server DBA

Microsoft

Bellevue, Washington

MID-SQL-SERVER-DBA-resume-sample

MID SQL SERVER DBA

SunTrust Bank

Atlanta, Georgia

SQL-SERVER-DBA-resume-sample

SQL SERVER DBA

Go daddy SQL SERVER DBA

Chandler, Arizona

About
  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
Help & Support
  • Work Here
  • Contact Us
  • FAQs
Languages
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
Customer Service
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2021, Bold Limited. All rights reserved.