Sr. SQL Database Administrator Resume

SUMMARY

Over 12 years of experience in Database/data warehouse Architecture, designing solutions based on SQL Server, Database Administration on Windows server platform, performance tuning, migration and disaster recovery.
Strong leadership and management skills including mentoring of Database Administrators, meeting deadlines and budgets.
Designed and implemented high availability solution to VLDB system using SQL Server technology: Always On, Database Mirroring, Windows Cluster wif SQL Server Cluster (Active/Passive, Active/Active), SQL Log Shipping, Service Broker technology.
Delivered security strategy such as TDE encryption, data isolation to system.
Developed DR process for Business Continuity Plan, tested and implemented in PROD environments that runs on SAN.
Rich experience on trouble shooting, organized, escalated issues and resolved based on type, severity, complexity and performance tuning of databases/system using features like DMV,SQL Profiler, Resource Governor, PerfMon, SQL Sentry.
Developed automated tools for performing routine maintenance works like Backup, Index - defragmentation and for scheduled jobs using scripting languages T-SQL, PowerShell and SQL Server Agent objects, Litespeed.
Maintained strong partnership wif stakeholders by having periodical status meeting and fulfilling their expectations.
Good exposure to all phases of SDLC- Software Development Life Cycle, starting from requirement analysis to operating the software released.
Worked as a Developer and created various components using C++, C# and PL/SQL

TECHNICAL SKILLS

OS: Windows 2k8 R2, IIS, Windows Cluster Services, PowerShell. SAN, RedGate tool, F5 (big IP), VSTF/TFS

SQL server technology: SQL Server 2012, SQL Server 2008 R2, SQL Server 2005. SQL Server Failover Cluster, Always on, Database Mirroring, SQL Replication, SQL Server Service Broker, SQLSSSIS, SQLSSAS, SQL Reporting Service.

PROFESSIONAL EXPERIENCE

Sr. SQL Database Administrator

Confidential

Responsibilities:

Achieved highly controlled, centralized, single data warehouse for Business Analytic team by having designed, consolidated into many DataMart into a SID data warehouse using star schema methodology.
Provided 99.00% (Service Level Agreement) availability in production environment by having right system architecture for data warehouse, strategy developed, regular maintenance plans in place.
Analyzed, planned, successfully executed SQL Server upgrade (SQL 2008 to SQL 2012) projects in all environments
Developed a tool using SQL Server objects to collect database size, row size for doing capacity planning.
Developed ETL process using SSIS packages.
Performed performance tuning, troubleshooting and releasing codes in PROD
Provided 24/7 on call - support on rotational.

Sr Operational Manager

Confidential

Responsibilities:

Performed capacity planning for PROD and built SQL Server environment based on new, expected capacity in a new datacenter for projects.
Planned, executed data center migration projects wif minimal downtime, and their database sizes varies from 1- TB to 16 TB using Database Mirroring/Log Shipping technologies
Build SQL servers by installing SQL Server 2012, configured Windows Clustering (Active/Active, Active/Passive), Always on and supported systems that have database of size 16 TB.
Performed performance tuning using SQL Server native tools and provided Tier III support to 400+ SQL Servers, wif 24/7 on call rotation, using incident management tool: TFS/VSTF
Involved in release management and deployed software releases in PRE and then PROD environment using deployment tool Octopus, Autopilot
Implemented SCOM Monitoring system for monitoring availability, performance, status of SQL Servers.

Sr. SQL Service Engineer

Confidential

Responsibilities:

Built physical system infrastructure in Bl2, BLU, AMS, DB3 datacenter for Windows Intune wif halp of GFS, from procurement of hardware to system running.
Designed and rolled out system wif high availability architecture using SQL cluster technology (SQL Server Mirroring, SQL Server Failover Cluster).
Built SQL Server by installing SQL Server 2008 R2, configured to run in all environments.
Developed BCP/DR plan, procedures, documented and tested the procedures in both Pre-Prod and PROD environments.
Designed, implemented and replaced SQL Server Replication technology wif SQL Service Broker technology to replicate data, which simplified the complexity of system, release process, and operational works.
Implemented SCOM monitoring environment for monitoring server availability and performance of Windows Intune system.
Developed escalation procedures and lead Tier 1, Tier 2 team who supports system globally.
Performed SQL Server upgrade (SQL 2000 to SQL 2005) projects starting from lower to higher environment.
Automated maintenance procedure like backup, index maintenance etc., using scripting language: TSQL, PowerShell
Provided 24/7 support services to all environments

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship