Jerry Coleman Email & Phone Number

Cincinnati, Oh, Us

Cincinnati, Oh, Us

• Responsible for the overall effective management of the DBA Team • Monitor, evaluate and report on the performance of the DBA Team members • Coach and mentor the team members to ensure effective and efficient DBA / system operations. • Manage the recruitment and retention of employees within the DBA team.• Diagnose and lead the resolution of database related issues. • Performs database code releases as required. • Database availability (capacity and maintenance)• Assures appropriate backup and recovery facilities are in place and functioning• Maintains sufficient redundancy for critical components. • Ensures appropriate monitoring and early warning systems are in place and functioning • Responds to database issues 24X7. • Performs maintenance work during scheduled outages. • Ensures that the availability of all production services is maintained at the highest possible level. • Creates High Availability to all critical database environments.• Performs yearly disaster recovery tests with all lines of business.• Ensures that the security of all group production services is maintained at the highest possible level including data encryption. • Ensures that appropriate diagrams and documentation describing all facets of the production environment are kept up to date and maintained to a high standard.• Advanced ETL and Reporting Development with enhanced SSIS/SSRS standards and end-to-end business delivery.• Knowledgeable using PowerShell scripting.• Designed a disaster recovery process using PowerShell to failover clustered SQL servers between data centers.

Hebron, Ky, Us

• Database management including performance tuning, disaster recovery and planning.• ERP integration with SQL databases• Reporting Warehouse management• Set up, configure and integrate Microsoft SQL server databases. • Perform on site and remote troubleshooting.• Work extensively with T-SQL code in deployments• Interface with UNIX systems• Perform diagnostic testing and system backups.• Develop processes for TSQL coding. • SQL 2008, 2005, 2000 database administration • Knowledgeable in Log-shipping, database mirroring • Worked with Data Warehouses and Data Cubes• Works with SQL Clustering • Works with SSIS, DTSX, DTS packages • Works with Reporting Services (SSRS) deployments• Decision maker in all aspects for SQL Server environments Developing plans for ITIL compliance in SQL environments.• Design and support of the database environment including all Quality Assurance, User Acceptance Testing, and Production application regions.• Serves as primary support for questions or issues on databases for all applications on a 7x24 basis.• Acts as liaison with 3rd party database support firms• Proactively monitor server health and performance using state-of-the-art tools and technology to ensure high availability and reliability of the DB application environment.• Design and implement all database security to ensure integrity and consistency among the various databases regions.• Implement and oversee all database code deployments and changes to the database environment to ensure integrity.• Anticipate and make recommendations with regards to the changing data and database needs based on industry

Randolph Afb, Tx, Us

• Responsible for assuring over 2,000 military reservists are trained in critical aspects of medical care and triage.• Developed and implemented a Wing Web site on Self Aid and Buddy Care • Served in Operation Iraqi Freedom. • Earned one Meritorious and three Air Force Achievement Medals • Trained active duty and reservists in patient movement. • Managed 30 reservists on a consistent basis, assuring training, evaluations and performance standards. • Received the "General's'" coin in developing a process to move wounded soldiers to key medical treatment facilities

Randolph Afb, Tx, Us

• Member of Medical Elite Response team responsible for immediate medical responses • Intensive care unit medical technician. • Promoted “Below the Zone” – promotion ahead of peers.

Computer Science, Computer Science

Business Intelligence Certification, Bi-Data Models And Data Warehousing

Mcitp, Sql Database Administration