Must Have Skills: Excellent verbal and written communication skills.
Excellent analytical skills, and problem solving skills.
Ability to communicate with all levels of the organization from Executives to support desk personnel.
Experience managing large and mission critical databases.
Proficient in performance and tuning of large database environment.
Working knowledge of MS and SQL software.
Knowledge of SOA.
Education: Bachelor's Degree
Description:
Panther Expedited Services, Inc. is currently seeking an IT Senior Database Administrator for our corporate office in Seville, Ohio. This role will be responsible for the planning, managing, and support of all database applications. Perform database tasks such as schema design, performance tuning, capacity planning, backups monitoring, maintenance, trouble shooting, and change control activities.
Will be responsible for all activities associated with the management and operation of database platforms: implementing data models and designs, creating database tables, indexes, triggers and views to support new and existing applications, design and implementing incremental and full backup policies and procedures, monitoring database size and performance, tuning SQL queries, developing prototypes to demonstrate proposed functionality, produce support documentation, and provide production support. Install software and maintain upgrades and patches, facilitate root cause analysis on database issues, manage security of application access to databases, perform benchmarking analysis to properly size hardware platforms, and maintain technical documentation relating to database management. Principal responsibilities include ensuring data integrity and performance of production databases. Support the development of data loads and extracts. Run diagnostics and maintain operation logs and documentation. Provide on-call support as needed.
Support departmental operations in a high-throughput production environment by proactively managing the performance, integrity, and security of Business Applications' databases and database servers.
Setup, monitor, and maintain disaster recovery solutions for production databases.
Design, create and maintain highly available and secure SQL Server database instances.
Create databases and database objects such as tables, indexes, views, triggers, and stored procedures.
Create and maintain customized database reports and perform data analysis.
Assist in the management of the hardware and software as related to the operations of the SQL Server DBMS, including system development, maintenance, and recommendations of purchases of new hardware and software.
Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
Responsible for synchronizing and migrating data and database objects between development, quality assurance, and production environments.
Mentor and provide support to Software Applications Developer in best practices for database design, programming, and tuning.
Work as a member of the technology team to assist in providing maximum availability and support of information technology systems.
Other duties as assigned.
Excellent verbal and written communication skills.
Excellent analytical skills, and problem solving skills.
Ability to work independently and plan/prioritize their own workload.
Ability to communicate with all levels of the organization from Executives to support desk personnel.
Ability to manage project teams in a flexible, fast-paced environment.
Experience managing large and mission critical databases.
Proficient in performance and tuning of large database environment.
Working knowledge of MS and SQL software.
Knowledge of SOA.
Previous experience with Cognos software helpful but not required.
Previous project management experience helpful but not required.
Bachelor’s Degree or higher.
Minimum 3 years’ experience coordinating and/supporting IT business processes.