SUMMARY:

Computer professional with over 15 years of experience. Knowledgeable and experienced with SQL Server SQL 2017, 2106, 2014, 2012, 2008R2, 2008, 2005, 2000 & 7.0, Windows 2019, Windows 2016, 2012, 2008, 2003 & 2000 Server, MS AZURE (IAAS & PAAS), VmWare, WFSC (Clustering), ERP PeopleSoft, SharePoint, IIS, Exchange, Citrix Metaframe, Terminal Server, Veeam, Netbackup, Project Management, RFP, Risk Management, PCI and SOCKS.

SKILL:

HARDWARE: Compaq Proliants, Dell 710, Power Edge, IBM RISC 6000, SUN SPARC, HP 3000, HP 9000Net Frame, Cisco Routers, 3COM, Wellfleet, Synoptic, Cubix and Cabletron

OPERATING SYSTEM: SQL 2017, 2016, SQL 2014, SQL 2012, 2008 R2, 2008, 2005, 2000 & 7.0, Windows 2019, 2016, 2012, 2008 R2, 2008, 2003 & 2000 Server, IIS 8.0, 7.0, Windows 2000 Workstation, Windows 7,98, Windows 95, NT Workstation, Windows XP

Cloud: Azure (IAAS & PAAS), Resource Groups (Data Factor, Security, Subscriptions VM Security, Data/Schema Import/Export, Databases SSIS, Web/Worker & VM roles)SOFTWARE: Solarwinds, TFS/ Octopus, Redgate ToolBelt,,SQL Sentry, Spotlight & FogLight, Powershell, IDERA SQL Performance, Service Now, SQL DB Artisan, DB Change Manager, LightSpeed, COMM Vault, IDERA (SQL Safe & Admin Tools), Red Gate SQL Compare, LoadRunner & Mercury Test Data tools, Visual Basic InterDev, Visual SourceSafe, Erwin, Skype For Business, MS SharePoint, Pulse Secure VPN Client, LANDesk, Nagios, MS Office 2010, 2003, 2000 & 97, MS Project Manager, Cisco VPN, FTP, SMS, Truesight, Sitescope, Netscaler, Unicenter, Exchange, Microsoft PSDIAG & Read80Trace, Tidal Job Scheduler, Microsoft Baseline Security Analyzer, Cisco VPN Client, Lotus Notes Mail

PROFESSIONAL EXPERIENCE:

SR. SQL DBA Architect\Lead

Confidential, Irving, Texas

Responsibilities:

• SQL Architect/Lead of SQL Server 2017, 201, 2008R2 on Windows Server 2016, 2014 and 2012
• SQL Architect/Lead of SQL DBA team of 2 DBA’S on site
• Designing/ Migrating to SQL 2017, 2016 from SQL Server (2008, 20008 r2) to Azure IAAS
• Designed and implement SQL Server TDE
• Analyzing SQL environment and the providing SOW & project plans implement recommend new SQL Blue Print Architecture
• Designed Architecture for SQL Clustering with Active/Passive Nodes and also SQL Multi - Instances. SQL High Availability Always on (Databases, Replicas, Listeners) SQL 2016 & SQL 2012 (Asynchronization and Synchronization), SAN Configuration and SSD and along with Firewall Rules and Ports.
• Architecting data with Data Mining and DataWarehousing
• Provided from a SQL Server Migration Blue Print Architecture written and hands on to SQL 2016 from 2012, 2008R2/2008, 2005, 2000 to a Private Network. H/W, S/W, Application, Storage, security, HA Groups and Active/Passive Clustering
• Supporting Developers code, solving performance issues of applications, SQL Jobs, SSRS & SSIS issues
• Created, assigned and managed SQL environment SOW projects and Deliverables for SQL Server Migration and upgrades
• Provided details Project Plans for the new SQL 2016 Architecture along with all recommendations proving POC as well
• Working with Managing SQL Server Vendors on Software, Tools, Licensing)
• DB design review and provide enhancements of various SQL Server Applications
• Creating, implementing and support SQL Environment Standard Operating Procedures
• Writing T-SQL Queries, Optimizing Stored Procedures, Views and Functions
• Backups and Restores using Maintenance Plans and SSIS custom packages (Recommend 3rd party SQL backup product to use and get approval for it.
• Creating, maintaining and supporting SQL jobs with Step(s) and E-Mail notification on Job failures to DBA team
• Capacity Planning, implementation and support (using Veritas, Window Server Manager, SAN, SSD, Redgate, FogLight and SQL SSMS
• SQL Automation (implemented and wrote documentation for all required processes for SQL Automation)
• SQL Security (SQL Logins and Mixed Mode Authentications), Roles, AD groups
• SQL Server Database Mirroring
• SQL Server Transactional Replication, Snapshot Replication
• Data Migration (installed, configured and supporting Microsoft SSMA with Oracle and, MS Access
• Created, Implemented and supporting SQL Server DB (Single DB Files and Filegroups)
• Creates, implements and supports SQL Server Maintenance Plans/Jobs (DBCC jobs, Index Tuning and Update Statistics
• Creates, implements and supports SQL Patch releases/Patches implements and supports Application releases/Patches
• Code Review and Approval for Prod and Staging environments
• Enhancing SQL Server Databases Design improvements with Application Development Manager and Lead on DB Architecture
• Created and implement SQL Server DBA Environment Operational and Best Practices Guides working with DBA team
• Managing SQL Server Environment Project and Deliverables with Project managers, IT, Application management and Power Application Users
• Accessing SQL technology and SQL Tools moving environment into being majority proactive
• Working Service Now Application for all SQL Server tickets
• Creating, implement and support all SQL Server environment
• Troubleshooting all SQL Server issues with (FogLight, and Idera, SQL SSMS,, SQL Queries, Stored Procedures, SQL Error and Windows Server logs
• Created and implemented SQL DBA Operations Guide for all DBA’s
• Managing Patch Releases (SQL Server and Applications)
• Managing Vendors with their Databases/Applications or SQL Servers

SR. SQL DBA/Lead

Confidential, San Antonio, Texas

Responsibilities:

• SQL Architect/Lead of SQL DBA team of 3 DBA’S on site
• Analyzing SQL environment and providing project plans & SOW implement recommend new SQL Blue Print Architecture
• SQL Architect/Lead of SQL Server 2017, 201, 2008R2 on Windows Server 2016, 2014 and 2012 on 98% VmWare and 2% on Physical Servers
• Designed Blue Print for SQL Clustering with Active/Passive Nodes and also SQL Multi-Instances. SQL High Availability Always on(Databases, Replicas, Listeners) SQL 2016 & SQL 2012 (Asynchronization and Synchronization), SAN Configuration and SSD and along with Firewall Rules and Ports. Certain Apps didn’t migrate to the cloud
• Designing/ Migrating to SQL 2017, 2016 from SQL Server (2008 R2/2008, 2005, 2000) to Azure
• Data Architecture of SQL Server Operations and application best practices
• DB design review and provide enhancements of various SQL Server Applications
• Supporting Developers code, solving performance issues of applications, SQL Jobs, SSRS & SSIS issues
• Provided a SQL Server Migration Blue Print Architecture written and hands on to SQL 2016 from 2012, 2008R2/2008, 2005, 2000 to a Private Network. H/W, S/W, Application, Storage, security, HA Groups and Active/Passive Clustering, Maintenance Plans, SQL
• Created, assigned and managed SQL environment SOW projects and Deliverables for SQL Server Migration and upgrades
• Provided details Project Plans for the new SQL 2016 Architecture along with all recommendations proving POC as well
• Writing T-SQL Queries, Optimizing Stored Procedures, Views and Functions
• Working with Managing SQL Server Vendors on Software, Tools, Licensing)
• Creating, implementing and support SQL Environment Standard Operating Procedures
• SQL Server Transactional Replication, Snapshot Replication
• Backups and Restores using T-SQL, Maintenance Plans and SSIS custom packages (Recommend 3rd party SQL backup product to use and get approval for it.
• Architecting new SQL jobs, creating, maintaining and supporting SQL jobs with Step(s) and E-Mail notification on Job failures to DBA and app teams to import and export data on SQL, from Oracle, MS Access and MS Excel
• Capacity Planning, implementation and support (using Veritas, Window Server Manager, SAN, SSD, Redgate, FogLight and SQL SSMS)
• SQL Automation with Red Gate, T-SQL, SQL Jobs
• Wrote the majority of SQL documentation for all required processes
• SQL Security (SQL Logins and Mixed Mode Authentications), Roles, AD groups
• Creates, implements and supports Blue Print using SQL TDE
• Data Migration (installed, configured and supporting Microsoft SSMA with Oracle and, MS Access
• Created, Implemented and supporting SQL Server DB (Single DB Files and Filegroups)
• Creates, implements and supports SQL Server Maintenance Plans/Jobs (DBCC jobs, Index Tuning and Update Statistics
• Creates, implements and supports SQL Patch releases/Patches implements and supports Application releases/Patches
• Code Review and Approval for Prod and Staging environments
• Enhancing SQL Server Databases Design improvements with Application Development Manager and Lead on DB Architecture
• Created and implement SQL Server DBA Environment Operational and Best Practices Guides working with DBA team
• Managing SQL Server Environment Project and Deliverables with Project managers, IT, Application management and Power Application Users
• Accessing SQL technology and SQL Tools moving environment into being majority proactive
• Working Service Now Application for all SQL Server tickets
• Creating, implement and support all SQL Server environment
• Troubleshooting all SQL Server issues with (FogLight, and Idera, SQL SSMS,, SQL Queries, Stored Procedures, SQL Error and Windows Server logs
• Created and implemented SQL DBA Operations Guide for all DBA’s
• Managing Patch Releases (SQL Server and Applications)
• Managing Vendors with their Databases/Applications or SQL Servers

SR SQL DBA Lead/Architect

Confidential, Dallas, Texas

Responsibilities:

• Lead of SQL DBA Consultant of team of three DBA’S on site
• Architected details Project Plans for the new SQL 2016 Architecture along with all recommendations proving POC as well
• SQL Analysis and Inventory and created documentation for SQL Blue Print to 2016 I created/presented in PowerPoint, Visio and Word
• Writing T-SQL Queries, Optimizing Stored Procedures, Views and Functions
• Managing/Lead of SQL Server 2017, 201, 2008R2 on Windows Server 2016, 2014 and 2012 on physical and VMware Servers with SQL Clustering with Active/Passive Nodes and also SQL Multi-Instances. SQL High Availability Always on(Databases, Replicas, Listeners) SQL 2016 & SQL 2012 (Asynchronization and Synchronization), SAN Configuration and SSD and along with Firewall Rules and Ports.
• Provided from a SQL Server Migration Blue Print Architecture written and hands on to SQL 2016 from 2012, 2008R2/2008, 2005, 2000 to a Private Network. H/W, S/W, Application, Storage, security, HA Groups and Active/Passive Clustering, Maintenance Plans, SQL
• Created, assigned and managed SQL environment SOW projects and Deliverables
• Using Solarwinds & Foglight to monitor, manage and troubleshoot all SQL Server
• Capacity Planning, implementation and support (using Veritas, Window Server Manager, SAN, SSD, Redgate, Solarwinds FogLight and SQL SSMS)
• SQL Automation with TSQL and RedGate Tools
• Working with Managing SQL Server Vendors on Software, Tools, Licensing)
• Data Architecture of SQL Server Operations environment
• Architected DB designed enhancements of various SQL Server Applications
• Creating, implementing and support SQL Environment Standard Operating Procedures
• Architecture SQL Server Database Mirroring
• Architecture SQL Server Transactional Replication, Snapshot Replication
• Provided LiteSpeed Backup Architecture and roll out with hands on for Backups and Restores
• Creating, maintaining and supporting SQL jobs with Step(s) and E-Mail notification on Job failures to DBA team
• SQL Security (SQL Logins and Mixed Mode Authentications), Roles, AD groups
• Creates, implements and supporting Blue Print using SQL TDE
• Data Migration (installed, configured and supporting Microsoft SSMA with Oracle and, MS Access
• Created, Implemented and supporting SQL Server DB (Single DB Files and Filegroups) implements and supports Application releases/Patches
• Code Review and Approval for Prod and Staging environments
• Re-Architecture SQL Server Databases Design and with Applications
• Managing Patch Releases and Updates (SQL Server and Applications)
• Managing Vendor Technology Quotes for SQL Servers
• Created and implement SQL Server DBA Environment Operational and Best Practices Guides working with DBA team
• Managing SQL Server Environment Project and Deliverables with Project managers, IT, Application management and Power Application Users
• Managing Patch Releases (SQL Server and Applications)
• Managing Vendor Technology Quotes for SQL Servers
• Accessing SQL technology and SQL Tools moving environment into being majority proactive
• Creating, implement and support all SQL Server environment
• Created and implemented SQL DBA Operations Guide for all DBA’s

SR. SQL DBA

Confidential, Dallas, Texas

Responsibilities:

• Production control and support
• Deploying application packages to production environment.
• Ttriaging, supporting, and managing production issues, incidents.
• Provided Root cause identification Incident/problem management
• SQL 2012, 2014 and 2016 Support, backups, restores, security, patch deployment
• DB performance analysis, tuning and issue resolution
• Maintenance automation tools or scripts
• Collaborating and mentoring (teaching) others.
• Microsoft SQL RDBMS Clustering installations and configuration and troubleshooting
• Performanced T-SQL Script writing, testing, and debug in large software application systems
• Designing ETL tasks, using Microsoft technologies (DTS, SSIS)
• Systems configuration (Windows OS) to adhere to best practices for Microsoft SQL RDBMS platforms.
• SQL Support using native and third-party tools (SQL Sentry, Quest SQL Performance Analyzer, RedGate SQL Toolbelt, etc.) to support Microsoft SQL RDBMS databases.

SR SQL DBA/Lead

Confidential, Dallas, Texas

Responsibilities:

• Managing/Lead of SQL Server 2017, 201, 2008R2 on Windows Server 2016, 2014 and 2012 on physical and VMware Servers with SQL Clustering with Active/Passive Nodes and also SQL Multi-Instances. SQL High Availability Always on(Databases, Replicas & Listeners) SQL 2016 & SQL 2012 (Asynchronization and Synchronization), SAN Configuration and SSD and along with Firewall Rules and Ports.
• DBA Lead over onsite DBA and Vendor Brent Ozark
• Writing T-SQL Queries, Optimizing Stored Procedures and Views
• Created SQL Server Migration Blue Print from 2008/2012 to SQL Server 2016 to a internal Private Cloud Network (H/W, S/W, Application, Storage, security, HA Groups and Active/Passive Clustering, Maintenance Plans
• Created, assigned and managed SQL environment SOW projects and Deliverables
• Managing SQL Server Vendors (Hardware, Software, Tools, Licensing)
• Providing Blue Print for the new proposed SQL Server Operations environment
• DB design review and provide enhancements of various SQL Server Applications
• Creating, implementing and support SQL Environment Standard Operating Procedures
• SQL Server Backups and Restores
• Creating, maintaining and supporting SQL jobs with Step(s) and E-Mail notification on Job failures to DBA team
• Capacity Planning, implementation and support (using Veritas, Window Server Manager, SAN, SSD, SQL Sentry One, Redgate, Sentry One & Solarwinds
• SQL Automation
• Approving SQL deployments of SQL Developers/Application teams
• LoadRunner & Mercury Test Data tools
• Installed/Configured and supports SQL Server Database Mirroring
• Installed/Configured and supports SQL Server Transactional Replication, Snapshot Replication (Publishers, Subscribers and Informatica Power Exchange replication tool), monitor with Replication Monitor, SQL scripts and Replications jobs
• SQL Security (SQL Logins and Mixed Mode Authentications), Roles, AD groups
• Creates, implements and supports Blue Print using SQL TDE
• Data Migration (installed, configured and supporting Microsoft SSMA with Oracle and, MS Access
• Created, Implemented and supporting SQL Server DB (Single DB Files and Filegroups)
• Creates, implements and supports SQL Server Maintenance Plans/Jobs (DBCC jobs, Index Tuning and Update Statistics
• Creates, implements and supports SQL Patch releases/Patches implements and supports Application releases/Patches
• Code Review and Approval for Prod and Staging environments
• Enhancing SQL Server Databases Design improvements with Application Development Manager and Lead on DB Architecture
• Created and implement SQL Server DBA Environment Operational and Best Practices Guides working with DBA team
• Managing Patch Releases (SQL Server and Applications)
• Managing Vendor Technology Quotes for SQL Servers
• Managing SQL Server Environment Project and Deliverables with Project managers, IT, Application management and Power Application Users
• Accessing SQL technology and SQL Tools moving environment into being majority proactive
• Working Service Now Application for all SQL Server tickets
• Creating, implement and support all SQL Server environment
• Troubleshooting all SQL Server issues with (SQL Sentry One, Foglight, SQL SSMS, SolarWinds SPLUNK, SQL Queries, Stored Procedures, SQL Error and Windows Server logs, Documentation using (Microsoft IT Notebook, MS Word, MS Project, PowerPoint and Excel)

SR. SQL DBA/Lead

Confidential, Dallas, Texas

Responsibilities:

• Architecture fDesigning/ Migrating to Azure IAAS (Azure (IAAS & PAAS), Resource Groups (Data Factor, Security, Subscriptions VM Security, Data/Schema Import/Export, Databases SSS, Web/Worker & VM roles)
• SQL Monitoring (install, configuration, maintenance with Solarwinds and MS SCOM)
• Install/configuration/maintenance of SQL Servers (Physical, VMware) SQL 2014, 2016, SQL 2008 R2, 2008, 2005, 2000
• Writing T-SQL Queries, Optimizing Stored Procedures, Views and Functions
• SQL Clustering installation, design, implement & Support
• Data center migration SQL 2016, 20014, SQL 2008 R2, 2008, 2005, 2000 physical instances, SQL Clusters & VMware in a Prod, Stage, QA, Dev & test environment
• SQL High Availability Always on(Databases, Replicas, Listeners) SQL 2016, 2014 & SQL 2012 (Asynchronization and Synchronization), SAN Configuration and SSD and along with Firewall Rules and Ports.
• SQL Database & Server Migrations
• Migration of SQL Server 2008R2, 2012 to SQL 2016 to Azure
• Provide and implement migration path and plan to Azure
• Support SQL 2016 on Azure
• Created documentation of SQL Servers on 2016 to and on Azure
• LoadRunner & Mercury Test Data tools
• SQL backups & restores with NetBackup & Veeam
• Capacity planning SAN & Local storage recommendations and implementation
• Database design/de-normalization (Tables/Schema, Views, Stored Procedures, Views)
• Providing data reports from various required applications
• Performance tuning/optimization with SCOM, Idera, SQL Profiler traces, Perform monitor, SQL DB Tuning Wizard, Execution Plans, VmWare and Windows server tools.
• Disaster Recovery
• Provides R&D for new SQL Technology and tools (SQL 2014, Solarwinds, Veeam Backup, SSIS, SSRS, SAN storage for SQL VmWare & Physical Servers
• Writing T-SQL queries
• Recommending SQL Operations and Development best practices implementing both
• Installing/configuring, implementing and supporting SSIS, SSRS
• Writing SSIS packages, jobs & supporting them where requested
• SharePoint DBA support, migration and support for servers (Operations, Design and Performance and generating reports. Recommending best practices and assisting in the implementation.
• SQL database application support
• Link Servers for data important/export
• SQL Documentation (Operational, DBA Guide, Performance SSIS best practices, SharePoint best practices
• Application support with developers and end users

SR. SQL DBA

Confidential, SouthLake, Texas

Responsibilities:

• Data center migration SQL 2012, SQL 2008 R2, 2008, 2005, 2000 physical instances, SQL Clusters & VmWare in a Prod, Stage, QA, Dev & test environment
• SQL backups with Idera & Litespeed
• Capacity planning SAN & Local storage recommendations and implementation
• SQL Clustering design/implement & Support
• Performance tuning/optimization with Profiler traces, Perform monitor counters & Execution Plans
• Disaster Recovery
• Writing T-SQL queries
• Creating & supporting SSIS packages
• SSRS server designs & implementation
• Documentation
• SharePoint DBA support and migration
• SQL database application support
• Link Servers for data important/export
• Performance tuning/Optimization (Profiler/Perfmon, NETIQ, Solarwinds, T-SQL)

App/Sys/Programmer Specialist

Confidential, Dallas, TX

Responsibilities:

• SQL DBA Lead of 100 SQL Servers (Physical Clusters & Single Instances & VMware), (2012, 2008 R2, 2008, 2005, 2000). SQL DBA Lead 1 of Jr. SQL DBA
• Re-Architecture SQL Server environment upgrading to SQL 2012
• SQL Monitoring (install, configuration, maintenance with Solarwinds)
• Acted as the primary point of contact with customer SQL DB Applications
• Project management (meeting deliverables, timelines, and defining needed resources and all requirements specifications being defined/implemented
• Customer support to all related SQL DB/application/content questions
• Provided monitoring and constant evaluation of projects (status reports, SOW)
• Responsible for the quality control doing the actual implementation of software/applications with clients onsite.
• Provided ongoing input to onsite manager regarding all project related processes (Status, milestones, plans, status, deliverables, risk & issues).
• Participated with on going status/change incident meetings and report on project progress.
• Supported end users and provided DB/application where required providing great warm hand off of implemented software applications for SQL Databases.
• Working with Oracle DBA using PeopleSoft to Migrating data to SQL Datawarehouse
• Working with RFP’s
• Risk Management
• Performing Database Architecture Modeling
• SQL DBA Lead over 80 Web Application servers
• SQL DBA Lead over 20 Citrix applications on SQL back end
• SQL Lead working with application developers and support
• Manager/Support of 6 Active/Passive Clusters
• Working with EMC SAN team on configurations for SQL Servers
• Creating solutions that meets both external and internal customer’s data needs regarding marketing and advertising web applications.
• Mentor junior App Support, DBA and application management
• Implemented/support enterprise backup solution with Idera SQL Safe & SQL
• Setup/Configure & support Replication (Transactional & Snapshot)
• Setup/Configure & support DB Mirroring
• Create/support SSIS packages & jobs. Import/Export data using Excel, Access & text files into databases
• Managed databases from 1GB to 2 TB databases
• Patch management & deployment
• Working with secure DMZ’S for SQL Servers
• Performance monitoring, tuning & troubleshooting (Solarwinds, Profiler, Perfmon, SQL Dashboard & DTA)
• Experience on installing SQL Server and configuring SAN and Cluster server.
• Work under pressure to meet tight delivery timelines
• Interacts between application developers, vendors, managers and App support, Intel & VMware
• Working with Windows 2008 R2, 2008 & 2003 servers
• Administers, maintains, develops and implements policies and procedures
• Implements data models & database designs, data access & table maintenance codes; resolves database performance issues, database capacity issues
• Designed/Implemented DR plan (San Replication between sites)
• Code/Scripts Review of developers and Vendors
• Implement/Support SQL Security (Windows & SQL Authentication, roles and AD groups)
• Assess and develop long-term strategic goals for production databases in conjunction with data owners and managers. Act as a liaison between the developers, application support
• Design and implement redundant systems, policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Conduct research and make recommendations with servers, applications, database products, services and standards in support of procurement and development efforts; liaise with vendors and service providers for the selection and procurement for new technologies.
• Troubleshooting though DBA tools (SSMS, Solarwinds, Quest Foglight, Idera, Microsoft Performance Profiler & Monitor)
• 24x7 on call rotation
• Manages outsourced support resources to meet operational and delivery objectives
• Technical presentation to CIO, Director of Technical Services & other Department App Directors
• Worked with exporting and importing data with SSIS to from Oracle 10g and 11g with SQL Server databases
• Working with DB applications: Epic, Cloverleaf, HIM, Pharmacy, BedTracking, INFOSEC security, DigiSonics, EDMS, Radiology, Help Desk, IT Jail health (CIPS, Accuflo, Talyst), TrueCode, Ansos,APC Grouper Financial, Audit Leverage DB Server, Bio Medical Engineering,Bio-Rad, BlackBaud, CNA, Cardiology, Care Fusion,

SQL DBA

Confidential, FT Worth, TX

Responsibilities:

• Supported end users and provided DB/application where required providing great warm hand off of implemented software applications for SQL Databases.
• Assisted with pre-sales and marketing of SOW, applications, demos, writing against RFP RFIs & RFPs and responding to business problems customers brought up during meetings.
• Database administration of SQL 2005 on Windows 2003 and SQL 2008 and SQL 2008 R2 Servers on Windows 2008
• Standardized and configuration new SQL Servers
• SQL best practices
• Implemented & managed all SQL security
• Release Performance - responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load.
• Production Performance - reviewing production performance metrics to determine how changes are needed to prevent issues. Application\Database tuning
• Project management (meeting deliverables, timelines and defining needed resources and all requirements specifications being defined/implemented
• Customer support to all related SQL DB/application/content questions
• Provided monitoring and constant evaluation of projects (status reports, SOW and provided RFP'S)
• Responsible for the quality control doing the actual implementation of software/applications with clients onsite.
• Provided ongoing input to onsite manager regarding all project related processes (Status, milestones, plans, status, deliverables, risk & issues).
• Participated with on going status/change incident meetings and report on project progress.
• Liaison, between IT and tech services, communicated with Application support teams, to ensure everyone was aware of release schedules, turns, issues and fixes.
• Liaison, between IT and Vendor - Communicate any questions or issues that relate to database performance to the vendor. Discuss solutions with tech services Database Administration.
• Test\QA Application Database support - responsible for coordinating, communicating and executing turns for stored procedures, views, tables, DTS packages, and SSIS Packages within Development\QA.
• SQL Server Application Job Support - responsible for coordinating the creation and scheduling of application database jobs for all environments with Database Administration. First level of support responsible for: receiving all application job alert notifications, researching application job failures, rerunning application jobs as needed
• IT Resource - available to IT support team members to recommend ‘best practices’ when developing database processes (e.g. extracts\loads).
• Database Data Loading - data loading through application code, SSIS packages or imports.
• Database Data Extracting - data extraction through application codes, SSIS packages or exports.
• Database archiving\purging - responsible for determining what data should be archived\purged.
• Table Capacity monitoring - tracking growth of largest tables to determine ways to handle the growth, purges, creation of an archival system
• Batch Performance monitoring - monitoring the batch processes to ensure optimal performance.
• Maintenance Jobs - Create SQL jobs (SSIS, security, SQL scripts & database maintenance)
• Backup\Recovery - create Backup\Recovery jobs (Using Comm vault and SQL)
• Web Administration - Performed Installation, Configuration and Support of web servers, Web turn deployments, troubleshooting & performance monitoring
• Performance monitoring of SQL servers, Windows 2003 & 2008 servers & Web servers using SQL Perfmon, profile, SQL scripts, Solar Wind
• SQL Server Clustering Support Active Passive
• Created SQL &Web server & Application documentation
• Implemented Database Mirroring in Development
• Created SQL Server best practices for Security, Database Administration, Backups & restores, job management, Disaster recovery, patch deployment.
• Worked with Change control
• DB2 backup DBA
• Worked with exporting and importing data with SSIS to from Oracle 9x and 10x with SQL Server databases

SQL DBA (SQL SQL 2005, 2008, Environment)

Confidential, Louisville, KY

Responsibilities:

• Database Design - reviewing\approving database designs before moving to production.
• Supported end users and provided DB/application where required providing great warm hand off of implemented software applications for SQL Databases.
• Database Code - reviewing\approving database code before moving to production.
• Release Performance - responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load.
• Production Performance - reviewing production performance metrics to determine if\how changes are needed to prevent issues. Application\Database tuning - proactively reviewing database specific application code (e.g. stored procedures, packages, etc…) to ensure optimal application and database performance.
• Liaison, between IT and tech services, communicated with CAE Application support teams, to ensure everyone was aware of release schedules, turns, issues and fixes.
• Liaison, between IT and Vendor - Communicate any questions or issues that relate to database performance to the vendor. Discuss solutions with tech services Database Administration.
• Test\QA Application Database support – responsible for coordinating, communicating and executing turns for stored procedures, views, tables, DTS packages, and SSIS Packages within Test\QA.
• SQL Server Application Job Support – responsible for coordinating the creation and scheduling of application database jobs for all environments with Database Administration. First level of support responsible for: receiving all application job alert notifications, researching application job failures, rerunning application jobs as needed
• IT Resource – available to IT support team members to recommend ‘best practices’ when developing database processes (e.g. extracts\loads).
• Database Data Loading - data loading through application code, DTS packages, SSIS packages or imports.
• Database Data Extracting - data extraction through application code, DTS packages, SSIS packages or exports.
• Database archiving\purging – responsible for determining what data should be archived\purged.
• Table Capacity monitoring – tracking growth of largest tables to determine ways to handle the growth, purges, creation of an archival system, etc. This also entails managing the data stored in DataMart databases.
• Batch Performance monitoring – monitoring the batch processes to ensure optimal performance.
• Maintenance Jobs – Create SQL jobs (DTS, security, SQL scripts & database maintenance)
• Backup\Recovery –create Backup\Recovery jobs
• Managed databases from 50 GB to 2 TB
• Web Administration – Performed Installation, Configuration and Support of web servers, Web turn deployments, troubleshooting & performance monitoring
• Performance monitoring of SQL servers, Windows 2003 servers & Web servers using SQL perfmon, profile, SQL scripts, Truesight, HP open View, Sitecope)
• Windows Server 2003 Administration – Providing support, troubleshooting and configuration for SQL and web environment
• SQL Server Clustering Support
• Created SQL &Web server & Application documentation
• Supported Database Mirroring (Principal, Mirror & Witness)
• Worked on Sarbanes-Oxley Compliance

SQL DBA

Confidential, Dallas, TX

Responsibilities:

• Managed SQL 2005 & 2000 servers (Production, Staging, QA, Test and Development)
• NET Application Support with SQL developers on all SQL databases and supporting databases
• Created and Managed Tables, Indexes, Performance Tuning and Optimization of Databases, Stored Procedures, Indexes
• Installed, configure, Support SQL 2000 & 2005 Servers on Windows 2003 Servers
• Setup and Maintained SQL Server Security for SQL databases. Provided Disaster Recovery Plans.
• Profiler, Perfmon, Microsoft PSDIAG & Read80Trace for performance optimization
• Configure and Support SQL Database Backups & Restores
• Performed Merge replication on SQL Server Databases
• Implemented & Supported Security of SQL Databases in Production, Staging, QA, Development and Test Environments. SQL script deployment to all SQL Servers through Change Management
• Disk capacity management
• Application Support with SQL developers on all SQL databases and supporting databases
• Installed, Configured, Managed and Support of SQL 2000 & Servers
• Creating Reports from SQL Databases