OBJECTIVE:

• I have experience in SQL Server, Oracle, MySQL, and Epic Cache. My objective is to help companies with any of these technologies.

TECHNICAL SKILLS

• SQL Server 7.0 - 2016, T-SQL (procedures, triggers, functions), AWS, DTS/SSIS/SSRS, SQL Server Replication, Clustered SQL Servers, Management, Project management, Epic Cache, Disaster Recovery/Business Continuity, Oracle 12c, HIPPA, SOX, SAN technology, Data warehousing, Visual Basic 6.0, FoxPro 9.0, TCP/IP concepts, Crystal Reports, Microsoft Office, Microsoft Project, Active Server Pages, VBScript, Jscript, and HTML.

PROFESSIONAL EXPERIENCE

Confidential

DBA

Responsibilities:

• Played a key role in evaluating, establishing and conducting proof of concepts for database migrations.
• Created and maintained database inventory for tracking databases as they migrated to AWS.
• Helped to develop backup and recovery strategy for applications and database on Amazon s AWS platform.
• Consolidated several on - prem databases into one EC2 MariaDB instance using MySQL replication. The EC2 instance was them replicated to a consolidated MariaDB RDS instance.
• MySQL - migrated MySQL databases to Aurora RDS instances. This provided the customer with a DR solution for their mission critical system.
• Migrated SQL Server migrated all versions of SQL Server databases to EC2 and RDS instances.
• Oracle used AWS data migration services to migrate Oracle database to an RDS instance.
• Manage 130+ SQL Server instances
• Provide database administration, system analysis, design, development and support for SQL Servers running on physical and VMware virtual servers.
• Perform installation, performance tuning, client/server connectivity troubleshooting, query optimization, back-up/recovery, database consistency checks using, and monitoring
• Upgrade and apply service packs for SQL server
• Manage day-to-day user activities like creating logins, granting permissions, applying security for new users
• Created monitoring tools to capture and report on all database issues
• SSRS
• Setup SSRS reporting sites to support reporting needs
• Created SQL Server inventory and benchmark reports using SQL Server Reporting Services. Benchmark data is updated throughout the data for performance data.
• Develop ad-hoc reports for users
• Well versed in availability groups, log shipping, and clustering
• Database conversions
• Using SQL, SSIS, and FoxPro, converted AS400 ISeries database to SQL Server
• Provide day to day support of Oracle databases
• Manage mission critical application assuring that the database is available and that data is loaded every day as expected.
• Database services in compliance with all audit and regulatory requirements
• Database operations support, resolving repetitive and simple events and escalating more complex incident according to the standard operating procedures
• Evaluate new database technologies and tools
• Manage the development and production database environments with emphasis on security, availability and performance
• Provide on-call support for VMWare, Ctirix, Windows, Exchange, and Imprivata

Confidential

Database team lead / Disaster Recovery Project Manager

Responsibilities:

• Managed the DBA team’s projects, tasks, and goals to support 20 Oracle servers and 300 SQL Servers
• Backups, alerts, data recovery, table maintenance, performance monitoring and tuning - on all platforms (AIX, HP-UX, Linux, Windows)
• Administered SQL Server 7, 2000, 2005, and 2008 database servers (including clusters)
• Implemented database processes and procedures for all databases in use
• Created custom monitoring/alerting tool to verify SQL Server database health 24X7
• Participated in the management and development of SQL server views, triggers & stored procedures
• Data migrations
• Migrated text data using SQL and FoxPro into SQL Server
• Epic Cache database support
• Epic certified Caché System Manager on Unix
• Performed all maintenance and monitoring of Epic databases for Confidential
• Installed/upgraded Caché
• Applied SU packages
• Setup DR and reporting shadow servers
• Applied security - adding, enabling, and deleting users
• Performance monitoring
• Configured RedAlert and System Pulse monitoring
• Refreshed environments
• Managed all disaster recovery IT projects including:
• SRDF replication from production data center to hot site
• Data Domain installation and setup - eliminate tapes for backup
• Application recoveries involving technical teams and application owners
• Two quarterly DR exercises involving all teams (Windows, Unix, TSM, SAN, database, network, and application)
• Annual 72-hour offsite DR exercise
• Recovered over 50 applications and 100 servers in a short period of time
• Coordinated efforts from all IT teams:
• Management
• Operations - assemble and ship tapes
• Technical - Windows, Unix, TSM, SAN, database, network
• Application - Configuring and testing the applications
• Vendors - If needed to configure/recover the application
• Hot site personnel
• Server installation - Unix/Windows server installs including cabling and power, network setup, and SAN
• Database projects - processes, recovery, upgrades, audits, etc.
• Met regularly with the customer to review project status and define expectations

Confidential

Database administrator

Responsibilities:

• Provided database administration, system analysis, design, development and support for SQL Servers (2008, 2005, 2000, and /7.0/6.5,6.0)
• Performed installation, performance tuning, client/server connectivity troubleshooting, clustering, query optimization, back-up/recovery, database consistency checks using, and monitoring
• Upgraded and applied service packs for SQL server and Oracle
• Used tools like SQL Server Management Studio (SSMS), SSIS, SSRS, SQL Server Profiler, SQL Server Agent, Execution Plan, Performance monitor, DBCC commands and troubleshooting and SQL Server Surface Area Configuration, Database Engine Tuning Advisor, BCP and Bulk Load
• Developed reports for Business Intelligence/Data Mining using MS SQL Reporting Services (SSRS)
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users
• Developed maintenance plans to collect database statistics, to run database integrity checks
• Developed capacity planning reports estimating the growth and usage of the databases
• Implemented many types of high availability such as Clustering, Database Mirroring, Log Shipping, and Replication
• Used software development life cycle (SDLC) and project methodologies
• Automated the database maintenance tasks by creating jobs and alerts using Database Mail and SQL Server Agent

Confidential

Database administrator/IT team lead

Responsibilities:

• Managed team of 4 Visual FoxPro programmers
• Maintained SBT inventory system in Visual FoxPro including programming changes and enhancements
• Created HTML reports for clients to access from company web site
• Designed and tested fulfillment application per individual client specifications in Visual FoxPro
• Import unique client data for scrubbing and manipulation
• Generated marketing reports for clients
• Interacted with clients heavily in determining goals and needs
• Created and maintained SQL Server 6.5 data warehouse using client data for ad-hoc reporting