We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Los Angeles, CA

SUMMARY

  • An accomplished, results - driven Senior Database Administrator wif 10 years of progressive experience in area of Database Management. Extensive Technical noledge on Microsoft® SQL Server™ 2014/2012/2008 R2
  • Management, Backup/recovery, Disaster Recovery, High Availability, Mirroring, Log-Shipping and Data Replication on homogeneous and heterogeneous system, DTS/SSIS, Capacity Planning & Performance Tuning on Query, MS Reporting/SSRS, MS OLAP/SSAS, OS, Database, Network and Device level to provide the best optimal Solution
  • Diagnosing & fixing the problems on the existing systems. Expertise on user and data’s security;
  • Experience in installation & configuration of scheduler; Experience in writing shell script stored procedure, function, trigger and in data warehousing;
  • Working noledge of TCP/IP communication.

TECHNICAL SKILLS

Operating Systems: Microsoft® Windows NT 2012R2/2008 R2, Microsoft® Active Directory, IBM® (UNIX) AIX 7.x, RedHat Enterprise AS Linux 7.2v, VM Ware ESX. VMotion.

Hardware: HP 9000 Superdome, Dell & HP Servers, EMC DMX SAN, Clarion CX700-400, IBM® p series 64bit servers

RDBMS: Microsoft® SQL Server™ 2014/2012/2008 R2/, Microsoft® Analysis Services OLAP, Oracle® Enterprise 11g, 10g Databases, Oracle® 12c, 11g RAC (Real Application Clusters), Oracle® Data Guard & OEM RMAN Implementation, Sybase ASE 12.5, 11.x, Sybase Replication Server 11.5

Applications: EAGLE/PACE Data Warehouse, Microsoft® .Net (VB.Net, ASP.Net, SQL.Net, C#), XML, VB 6.0, ASP, Microsoft® Cluster Server, StorageTek L4100M, Net Backup, Business Objects, Data Integrator ETL, iMTS™ Global Payment Processing, Serena® PVCS Tracker™ 6.0, Erwin™

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Senior Database Administrator

Responsibilities:

  • Investment Database Production Support.
  • ERP and Data Warehousing
  • Responsible for providing corporate technical expertise on Installation, Administration, Performance tuning of
  • Microsoft® SQL Server 2016 Migration
  • Microsoft® SQL Server 2014 Availability Groups & Clusters
  • ScaleArc Zero App Downtime
  • Oracle® Enterprise 11g,12c
  • MYSQL 5.6
  • Amazon Web Services EC2 & RDS Implementations
  • Attunity ETL Data Replication to cloud environment
  • Microsoft® SQL Server 2008 R2 64bit.
  • Microsoft® Cluster Server Windows NT 2012R2/2008 R2 64 bit
  • Enterprise implementation of Availability Groups, Data Mirroring, Log Shipping.
  • Transactional Replication to Europe.
  • VMware Server & ESX, VMotion for HA
  • IDERA Diagnostic Manager & Quest Light speed
  • EMC® DMX/Clarion SAN Solutions, SRDF, BCV, Time finder, TSIM.
  • Data Center migration to Plano, New York for services expansion and DR. Migration of QA environment to Amazon Cloud (AWS), EC2 and RDS.
  • Setup, Installation, upgrade & migration of existing systems to SQL Server 2014 from SQL Server 2012/2008
  • Setup for disaster recovery, fail over strategy, High Availability of system using MS Clustering, Database Mirroring, SQL Always On, Replication and EMC SRDF solutions.
  • Support for (24 x 7) and problem solving using available resources & making presenting recommendations for
  • Co-ordination, co-operation, guidance and direction to group of DBA
  • Scheduling, Planning and tasks/jobs assignment, mentoring to junior DBA teams.
  • Reporting to the Management about the project status and any impediments.
  • T-SQL Code review and performance tuning recommendations to developers.
  • Implementing SCRUM methodology for database development to monitor the progress of the existing projects
  • Involve in study, design, development and enterprise database architecture of the existing and new system
  • Involve in infrastructure design for its scalability of the system using MS Clustering, Database Mirroring, SQL Always On, Replication, load balancing
  • Database Maintenance and Troubleshooting
  • Error log monitoring for MSSQL Servers/ Replication Servers.
  • Database and Replication monitoring for optimal response and higher throughput using remote distributor
  • Database Backup & Recovery of databases
  • Security Audit’s and Compliance SOX.
  • Performance & Tuning of SQL Servers/ Replication Servers, Databases, systems, Networking configuration (optimal) and query optimization using SQL Query Analyzer/SSMS, Idera Diagnostic Manager.
  • Configure, setup the log shipping/ Database Mirroring/Replication/ Clustering/ Disaster recovery.
  • Involve in Design, develop and maintain logical/physical database model for new and existing system. Involve in Software Development Life Cycle for the existing and new systems.
  • Involve in Database Source Code and versioning Control using Microsoft Visual Source Safe/TFS and git.
  • Managed off shore projects and teams to design, develop, QA/test and launch the project in alpha stage.
  • Used the SSIS as ETL tools to move the data from various sources to the Warehouse system.
  • Data flow between Heterogeneous system using Attunity ETL and SSIS.
  • Designed, developed the data marts for the reporting services, using SSIS as ETL tools to pump the data from source to destination server.
  • Involve in installation, configuration, setup and monitoring of Mongo, PostgreSQL, and MYSQL.
  • Involve in the Architecture, design, development, testing and implementation of big data system in Hadoop

Confidential

Sr. SQL Database Administrator

Responsibilities:

  • Responsible for providing business units wif 24 x 7, enterprise support of database servers in excess of 300.
  • Investment Database Production Support.
  • ERP and Data Warehousing
  • Responsible for providing corporate technical expertise on Installation, Administration, Performance tuning of
  • Microsoft® SQL Server 2014 Migration
  • Microsoft® SQL Server 2012 Availability Groups & Clusters
  • Amazon Web Services EC2 & RDS Implementations
  • Attunity ETL Data Replication to cloud environment
  • Microsoft® SQL Server 2008 R2 64bit.
  • Microsoft® Cluster Server Windows NT 2012R2/2008 R2 64 bit
  • Enterprise implementation of Availability Groups, Data Mirroring, Log Shipping.
  • Transactional Replication to Europe.
  • VMware Server & ESX, VMotion for HA
  • IDERA Diagnostic Manager & Quest Light speed
  • EMC® DMX/Clarion SAN Solutions, SRDF, BCV, Time finder, TSIM.
  • Data Center migration to Plano, New York for services expansion and DR. Migration of QA environment to Amazon Cloud (AWS), EC2 and RDS.
  • Responsible for all Back Office and Compliance corporate database operations/support, troubleshooting and escalation to Microsoft product support.
  • Enforcing database standards for all locations and evaluating products for corporate wide deployment.
  • Tuning slow running queries, views and functions and writing TSQL code.
  • Data integrity checking along wif index tuning and performance monitoring using NET IQ, Embarcadero DB Artisan and Quest Central.
  • Experience managing and integrating applications utilizing: Microsoft .Net (VB.Net, ASP.Net, SQL.Net, C#), XML, VB 6.0, ASP.
  • Provide security and compliance SOX, SEC regulations reports for internal and external auditors.
  • Identity and Security management using dual factor identification and single sign on technology.
  • Excellent understanding of IT SDLC methodology, Change Management, Structured Project Management.
  • Responsible for developing high availability & disaster recovery planning and testing for all mission critical systems.
  • Responsible for configuration and deployment of SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services.

Hire Now