Database Administratot

As Database Administrator, you will be responsible for the design, implementation, and support of scalable data management solutions, as well as for forecasting system requirements and providing a course of action to meet the growing workload demands. You will collaborate with other departments to create standardized delivery of data management solutions that are aligned with enterprise strategy and architecture. You will define database maintenance standards and work with Operations to ensure these standards are implemented and followed consistently. You will occasionally propose enhancements to the daily operations of database systems.

Duties & Responsibilities:

• Maintain a highly available, reliable production database environment.
• Ensure and test the viability and reliability of database backups and recovery on a planned and unplanned basis.
• Monitor, capture, and conduct thorough performance analysis of our database systems to identify areas for improvement and optimization.
• Analyze and optimize database queries, stored procedures, and data access patterns to improve performance and efficiency.
• Evaluate and optimize database indexing strategies and schema designs to enhance query performance and reduce latency.
• Expand and shrink database storage as needed.
• Conduct capacity planning and scaling the system.
• Monitor job and transfer queues to ensure they are functioning as expected.
• Manage SQL Server databases through multiple product lifecycle environments, from development to production systems.
• Administer Microsoft SQL Server databases, develop and optimize applications and integrations using the Microsoft SQL Server platform.
• Develop, maintain and enhance imports, vendor exports, data warehousing tasks, reports, and other data related tasks.
• Conduct security and compliance reviews.
• Script and automate the day-to-day tasks.
• Define and promote best practices and standards for database performance tuning and optimization across the organization.
• Document tuning strategies, optimization techniques and best practices, and provide training and guidance to team members as needed.
• Promote and support continuous improvement with the SQMS.
• Respond to off-hours service impacting incidents, as needed.
• Perform other related duties as assigned.

Qualifications:

• Bachelor's degree in Computer Science with a minimum of five years SQL Server administration, or equivalent experience required.
• Extensive experience with Database Administration and system analysis including design, installation and troubleshooting of MSSQL Server required.
• Extensive experience with monitoring tools such as Ola Hallengren's scripts or Idera SQL Safe required.
• Extensive experience with Performance Tuning and Optimization required.
• Extensive experience with backups, restores, recoveries, and clones required.
• Strong analytical and problem-solving skills, ability to organize and prioritize multiple assignments, participate as a team leader or member of a team, work under pressure and complete job assignments in an accurate, timely and professional manner required.
• Excellent presentation, communication, interpersonal and customer service skills and ability to interact effectively and professionally with all learning styles, personality types and levels of management, staff, or external entities preferred.
• Microsoft Certified Database Administrator Certification preferred.
• Experience managing security within the SQL Server environment preferred.
• Experience working with Microsoft Office Suite (Excel, Word, PowerPoint) preferred.
• Proven ability to learn new skills to stay current with changing technologies and industry trends, and proactively share knowledge with others.
• Must be able to perform all functions of the job, including lifting up to 50 pounds.
• Must possess and maintain a valid State driver's license and is responsible to maintain all vehicles maintenance logs.
• Must be available to work nights and/or weekends when necessary.