Senior SQL Database Administrator Resume

SUMMARY:

Highly skilled, solutions oriented Microsoft Certified professional with 11 years of DBA experience. Specialize in Data Analysis and Modelling, Data warehouse Design and Development, High Availability, Data Migration, Report Development, Performance Tuning and T - SQL Programming

PROFESSIONAL EXPERIENCE:

Senior SQL Database Administrator

Confidential

Installed, configured and administered various instances of MS SQL (2008R2/2012/2014) and Oracle (10G), exceeding expectations with 100% uptime
Configured and Managed multiple SQL 2012 Cluster environment’s built on Veritas Storage Foundation, hosting critical application databases
Designed, Tested and Implemented Disaster recovery, High Availability and backup strategies using Windows Clustering and CommVault, enabling business continuity and speedy database recovery
Performed database physical design, database upgrades & applied software patches to databases as per requirements
Worked with development teams on analyzing large datasets and assisted in performance tuning and query optimization
Designed and implemented ad-hoc queries and reports using complex T-SQL and SSRS
Developed various SSIS packages to import reference data from various source files into SQL database
Design, document, and promote security "best practices", policies, standards and protocols.
Migrating application code and objects from development/test environments to production
Provide Windows System Administration and Monitoring support for technologies such as Active Directory, VMWare, SAN, SCOM, SCCM, Firewall
Performed capacity planning, project estimation and decommissioning process for SQL Instances
Developed processes and procedures for application code and database object migrations to support an efficient and reliable SDLC
Provided 24x7 on-call support for production systems

Senior Database Administrator/Developer

Confidential

Designed, Developed and managed 2 TB data warehouse solution from multiple sources using Cognos, SSIS, SSAS & SSRS , delivering an enterprise level data source for SA Lotteries reporting and decision making
Installed, configured and administered various MS SQL ( ) and supported various DB2 (LUW) and Sybase Instances, exceeding expectations with 100% uptime
Implemented disaster recovery solution using Database Mirroring and Replication, providing high availability for key enterprise systems
Data Modelling using Visio for all internal applications such as Data Warehouse, Agent Administration, Marketing Promotions
Successfully migrated SQL Server data warehouse and financial database from R2 environment
Successfully lead a migration project - from various data sources’ such as Flatfile, RDBMS, Excel, Access and XML to centralized SQL Server Data store
Efficiently resolved various database issues, such as performance, configuration and data recovery using tools such as such as SQL Profiler, Dynamic Management Views (DMVs), SSMS Standard Reports, and Performance Monitor (Perfmon), in production and non-production environments, in conformance with SLAs .
Developed, implemented and maintained standard reports and models using Report Builder, Cubes using MDX & Data tools, effectively catering for cross functional reporting requirements including Sales, Marketing and Finance
Design and developed key web applications to cater internal departmental requirements using ASP.Net, Jquery, HTML and T-SQL

SQL Database Administrator

Confidential

Installed, configured and administered various MS SQL (2000/2005), MS Access database systems exceeding expectations with 100% uptime
Lead a migration project - from various data sources’ such as Excel, Access, Word to centralized SQL Server Data store
Designed, Developed and Managed key organizational reports using Business Objects 6.5

TECHNICAL SKILLS:

MS SQL Server(7.0-2012), MS Access, DB2(LUW), Sybase, Oracle, Azure
SSRS, SSIS,SSAS, Report Builder, Cognos, BusinessObjects, PowerPivot, MOSS 2007
Perfmon, SQL Profiler, Data Studio, ITIL, ITSM
Windows ( ), Linux, IIS, VMWare, SAN, Firewall, commVault, Azure, Citrix asp.NET(C#,VB), Jquery, Powershell, Perl Script, T-SQL, MDX

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship