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.