SUMMARY

To seek challenges as Database Administrator of Client/Server and Internet - based business data processing applications.

Soft Skills:

• Interpersonal skills are essential for any job or position.
• me bring the following to the table: * Dedication * Multitasking * Team Player * Fast Learner * Flexible * Productive under pressure.

PROFESSIONAL EXPERIENCE

Confidential Warren, NJ

Senior SQL Server Database Administrator

Responsibilities:

• Supporting over 200 SQL Server 2008 and 2012 Enterprise edition databases for Verizon’s financial and HR departments.
• Participating in weekly change controls.
• Thorough documentation of new projects and existing environments.
• Managing group of junior DBA’s and coordinating team on-call duties and project timelines.
• Proofreading database code and advising developers on code errors and production performance improvements. Utilizing SQL Server showplan, dynamic management views and profiler traces to isolate performance bottlenecks, such as table scans, index inefficiencies, memory pressure, excessive blocking and so forth.
• Setting user- and group level securities, as well as creating and maintaining security for roles, linked servers and access to database server files and folders.
• Regular installation and patching of clustered SQL servers.
• Working closely with network, server and storage teams.
• Implemented and maintained Tivoli Storage Management tape backups, replacing local disk backups and saving storage space and maintenance costs. Created striped backups for large databases over 1TB in size.
• Implemented Disaster Recovery through logshipping solution.
• Daily performance tuning using SQL Server and third-party tools like Idera and LiteSpeed.
• In addition to my own and team’s expertise, utilized Microsoft’s, Dell’s, Idera’s and other companies’ support resources to halp resolve various technical issues.
• Automated multitude of repetitive administration tasks and minimized databases availability downtime. Implemented disk space, memory and CPU email and text alerts.
• Communicating with technical and business user teams for the purpose of gathering business and functional requirements and understanding end-user needs.
• Oracle Data Pump export and import to move data.
• Researched, worked on Proof of Concept, implemented and documented SQL Servers’ monitoring solution from Oracle Enterprise Manager.
• Implemented database maintenance, logshipping and database servers performance alerts.
• Migrating data from and into various data sources, such as from Oracle and Sybase to SQL Server and vice versa.
• Installed Oracle and MySQL drivers per development team’s requests
• Working closely with application, project management and other database teams.
• Researching new database technologies, such as MongoDB and creating related presentations for team and group presentations.
• The environment consisted of the following:
• Windows 2008/2012 Development, User Acceptance, Production and Disaster Recovery Servers, MS SQL Server 2008/2008R2/20012 Enterprise editions, Oracle EM monitoring, Oracle client drivers, LiteSpeed 7.5, Tivoli Storage Manager, VMware, Visual SourceSafe for code version control, Idera SQL Diagnostic Manager.

Confidential, New York, NY

Senior SQL Server Database Administrator

Responsibilities:

• Was responsible for the health and stability of all GLG’s MS SQL Server, MySQL and MongoDB databases.
• Resolved all database-related issues and worked closely with development, QA, project management and business users teams.
• Designed and implemented database maintenance tasks and backup strategy, including full, differential and transactional backups. Logshipping was used to copy data on a regular basis to a server, separate from production, for Dev teams to access and utilize scrambled data; created regular email alerts and database health checks.
• Participated in daily scrum meetings when company switched to Agile methodology.
• Deployed database objects into staging, production and DR environments
• Created and maintained numerous DTS and SSIS packages for IT and business-related ETL tasks.
• Designed, configured, maintained and performed troubleshooting of logshipping, transactional and merge replications. Created alerts for merge replication conflicts and consulted business users or developers to resolve these conflicts.
• Improved Snapshot, Log reader (for transactional replication) and Merge Agent’s execution performance, by creating separate agent profiles, that were used during production or QA environments-synchronization deployments.
• Performed regular production cluster node resources’ failovers and failbacks during production deployments.
• Designed and implemented database project to spin off new on-demand QA environments for testing purposes before major product releases.
• Evaluated, analyzed and provided estimates that were used in the purchase of the new database servers.
• Consolidated databases and decommissioned physical servers, saving thousands of dollars.
• Evaluated and implemented various third party tools, such as Confio Ignite, for SQL Server performance monitoring; also evaluated and implemented Lumigent AuditDB, for database-auditing purposes.
• Created SQL PERFORMANCE database for every SQL Server instance for the purpose of collecting, storing and purging server and database performance metrics, stored procedures execution’s duration, read/writes and other metrics. In combination with the use of Confio Ignite tool and SQL Server data management views, it greatly improved performance troubleshooting time and quality.
• Experience with and knowledge of T-SQL development, OLTP- and batch-based applications, as well as working closely with developers in object-oriented environment and suggesting database-related performance improvements in .NET front-end code.
• Developed, tested and deployed MySQL master-slave and master-master replication, as well as took training, installed and configured MongoDB replica sets in the company’s production cloud environment.
• The environment consisted of the following:
• Windows 2003/2008 Server, MS SQL Server 2005/2008/2008R2 Standard and Enterprise editions, Lumigent AuditDB, Confio Ignite monitoring tool, Ubuntu Linux, MySQL, MongoDB, VMware, TortoiseSVN (Subversion) for code version control, Navicat for MySQL, GlodenGate (now Oracle) Disaster Recovery software, NetApp.for network storage.

Confidential, New York, NY

Senior SQL Server and Sybase Database Administrator

Responsibilities:

• As part of Central Administrative Systems department, designed and supported over 300 databases on 60+ SQL and Sybase servers.
• Created logical and physical data model diagrams (using ErWin tool) and modeled complex relational databases.
• Implemented database growth email and pager alerts for the DBA group for the purpose of controlling space group and preventing database logs from consuming more TEMPthan 75% if servers’ hard disk space was approaching its capacity limit.
• Used Tivoli Monitoring and SQL Profiler to monitor various security and performance database- and server-level counters in order to isolate slow-running processes and unauthorized/non-compliant user access.
• Each production change request required Enterprise Change Management and Work Request ticket as well as approval of Application Development, IT Risk and DBA group.
• Implemented database accounts auditing for Security information management tool monitoring purpose, as per Sarbanes-Oxley Act - compliance project.
• Developed various disaster recovery strategies, such as transactional and snapshot replication, log shipping and full database backup, copy over network and restore.
• Used SQL Lightspeed third-party tool to compress backups for Anti-Money Laundering SQL Servers with 2-TB production database. The backup was being stored on NAS device and restored onto Data Recovery server.
• Worked closely with customer security specialists to define required security procedures for backup and recovery and to control access to the data. Monitored and fine-tuned databases performance.
• Designed and maintained hundreds of DTS packages, scheduled SQL Server jobs and Sybase cronjobs for Global Technology, Corporate Training and Real Estate business groups.
• Participated in the inventorization project for storing all corporate database servers’ information on the internal company’s website.
• The environment consisted of the following:
• Windows 2000/2003, IBM AIX, Compaq Tru64 5.0AMS SQL Server 2000-2005 Standard and Enterprise editions, Sybase
• 12.5.1-15.0, Sybase Replication server 12.5.1, Visual SourceSafe and PVCS for code version control.