Database Administrator jobs in Portland, ME

OFFICE OF INFORMATION TECHNOLOGY, MAINE IT

MAINE DEPARTMENT OF TRANSPORTATION APPLICATION DEVELOPMENT TEAM

Opening Date: April 22, 2024

Closing Date:  May 6, 2024

Job Class Code: 0189
Grade: 29
Salary: $69,535.44 - $93,838.19/Annually (includes 15% recruitment & retention stipend and eligible for 5% training bonus)
Position Number: 025000039

You are a talented senior-level professional who is driven toward success. You are a go-getter, always seeking ways to expand your knowledge, and encourage others to do the same. You enjoy clearing hurdles as you strive for excellence. If this describes you, we want you on our TEAM!! 

OVERVIEW:

The Department of Administrative and Financial Services (DAFS) Office of Information Technology provides information technology support to over 13,000 employees.  MaineIT oversees large-scale enterprise applications that support the critical and diverse business needs of the State of Maine and its agencies. This position will be part of our MaineDOT apps team supporting all the applications used by the Maine Department of Transportation.  

MaineIT is looking for a qualified and skilled individual who is self-motivated to be a part of a highly technical team supporting MaineDOT and who will represent our C.A.R.E. values in all they do. At MaineIT we:

• Practice Customer-focus, ensuring that our customers are heard, and their needs are met. 
• Hold ourselves to a high level of Accountability by being transparent with our stakeholders. 
• Maintain an effective level of Responsiveness by providing prompt updates in a proactive manner. 
• Strive to provide Empathy driven, people-focused services by applying emotional intelligence skills and behaviors.

BRIEFLY ABOUT THE JOB:     

This advanced technical and analytical position involves designing, developing, and supporting highly complex databases, data analysis, data modeling, and data integrations, supporting MaineDOT’s Enterprise Data Warehouse and other MaineDOT systems.   Candidates are expected to have strong problem-solving and organizational skills, excellent attention to detail, multitasking ability, able to lead an IT team and interact effectively with our business partners.

WHAT IS IN IT FOR YOU? 

Hybrid Work Opportunity – This position is a hybrid remote/onsite position. The onsite location is in Augusta, Maine and the remote location must be within the state of Maine.

• You will have an opportunity to have fun, learn and develop new skills while working with a highly talented and dedicated team of software developers and key stakeholders at MaineDOT.
• You will be analyzing issues and design solutions resulting in projects of various sizes.
• You will help resolve technical issues to provide system functionality and data integration.
• You will have the opportunity to add to your experience and ability in a collaborative working environment.
• You will experience new and different challenges on an ongoing basis.

WHAT WILL YOU DO?

Your job as a Data Architect will have responsibility for supporting MaineDOT’s Enterprise Data Warehouse solution and a Data Integration strategy for all MaineDOT systems.  Other duties will include:

• Translating business requirements into databases, data warehouses, and data streams.
• Creating procedures to ensure data accuracy and accessibility.
• Analyzing, planning, and defining data architecture framework, including security, reference data, metadata, and master data.
• Creating and implementing data management processes and procedures.
• Collaborating with other teams within the organization to devise and implement data strategies, build models, and assess shareholder needs and goals.
• Researching data acquisition opportunities.
• Developing application programming interfaces (APIs) to retrieve data.

Work will involve frequent communications with our MaineDOT Business Partners, MaineDOT AppDev peers, Software Vendors, and other MaineIT Technical Staff.  

Preference will be given to candidates who display a high-level skill set in the following areas:

• Data Analysis  
• Data Modeling and Design
• Data Migration Tools Knowledge
• Data Integration / API Development
• Database development standards
• Oracle Analytics Cloud
• Strong oral and written communications
• Strong desire to provide great Customer Service
• Ability to define and resolve complex technical problems independently and in a team environment.

MINIMUM QUALIFICATIONS

• Eight (8) years of progressively responsible and increasingly complex work experience in computer programming, analysis, and design with at least four (4) years of database analysis and design experience. A Masters Degree in Computer Science may substitute for one (1) year of the general computer programming/analysis/design experience.

Preference will be given to those who submit a cover letter with their resume to be considered for an interview.

The selected candidate will be required to sucessfully pass the required background checks as a condition of employment.

Benefits of working for the State of Maine:

No matter where you work across Maine state government, you find employees who embody our state motto—"Dirigo" or "I lead"—as they provide essential services to Mainers every day. We believe in supporting our workforce's health and wellbeing with a valuable total compensation package, including:

• Work-Life Fit – Rest is essential. Take time for yourself using 13 paid holidays, 12 days of sick leave, and 3 weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave.
• Health Insurance Coverage – The State of Maine pays 85%-100% of employee-only premiums ($10,523.28-$12,380.40 annual value), depending on salary. Use this chart to find the premium costs for you and your family, including the percentage of dependent coverage paid by the State. 
• Dental Insurance – The State of Maine pays 100% of employee-only dental premiums ($350.40 annual value).
• Retirement Plan – The State contributes the equivalent of 13.41% of the employee's pay towards the Maine Public Employees Retirement System (MainePERS). 

State employees are eligible for an extensive and highly competitive benefits package, covering many aspects of wellness. Learn about additional wellness benefits for State employees from the Office of Employee Health and Wellness.

Note: Benefits may vary somewhat according to specific collective bargaining agreements and are prorated for part-time employment.

There's a job and then there's purposeful, transformative work. Our aim is to create a workplace where you can learn, grow, and continuously refine your skills. Applicants demonstrate job requirements in differing ways, and we appreciate that many skills and backgrounds can make people successful in this role. 

As an Equal Opportunity employer, Maine State Government embraces a culture of respect and awareness. We are committed to creating a strong sense of belonging for all team members, and our process ensures an inclusive environment to applicants of all backgrounds including diverse race, color, sex, sexual orientation or gender identity, physical or mental disability, religion, age, ancestry, national origin, familial status or genetics. 

If you’re looking for a great next step, and want to feel good about what you do, we’d love to hear from you. Please note reasonable accommodations are provided to qualified individuals with disabilities upon request.

Thinking about applying?

Research shows that people from historically excluded communities tend to apply to jobs only when they check every box in the posting. If you’re currently reading this and hesitating to apply for that reason, we encourage you to go for it! Let us know how your lived experience and passion set you apart.