Database Administrator

The Steamship Authority is seeking to fill the position of Database Administrator who will perform a key role in all areas of database management, maintenance, monitoring, and support across all IT applications. 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 And 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.
• Responds to off-hours service-impacting incidents, as needed.
• Performs 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 MS SQL 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.

Interested parties should submit a letter of interest and resume to hr@steamshipauthority.com.

Human Resources Office
Steamship Authority
228 Palmer Avenue
Falmouth, MA 02540

EOE