Job Description: Job #: 1045552
Apex Systems is hiring a Database Engineer to support a client initiative out of Hartford, CT. You can find the job description and project details below. If you are interested, feel free to send your resume to [ Link Removed ] .
The client is currently undertaking database improvement initiatives that support key applications using Microsoft SQL Server. These initiatives may be in addition to, or a variation of recommendations listed in the document, and must:
Provide a stable and well-performing database infrastructure.
Allow for the maintenance and expansion of the enterprise e-government solutions.
Leverage Microsoft best practices.
Take advantage of and be compatible with the targeted Microsoft SQL platform enhancements as intended (SQL Server 2016 v 2017 etc.).
Support accurate financial data and accounting principles where applicable.
Be prioritized and approved in concert with client business stakeholders.
Be tested in a Staging environment with appropriate business testing/signoff prior to Production deployment.
Include a Production Bill of Materials with a roll-back plan such that any related databases (and applications) can be recovered following a failed or error-inducing rollout.
Have Production deployments that are appropriately scheduled for content and duration
singly/multiply, based on risk, roll-back considerations, length of deployment, user interruption etc.
Statement of Work
Review full DB Assessment document, with analysis of current enterprise SQL DB instances, to assess priorities with client staff
As needed, schedule sessions with business stakeholders and OIM staff to analyze business data requirements and data flows
Design and implement all required database documentation, code, database objects, scripts, stored procedures, etc. to achieve the agreed-to DB initiatives. Work will be archived on TFS and/or Sharepoint as directed.
Prepare and maintain the Project Management Plan (the "PMP"), which lists the activities, tasks, assignments, milestones and estimates, including:
Integrated Project Plan
Quality Assurance and Document Control Plans and Processes
Delivered Materials Tracking and Acceptance Processes
Scope, Risk and Issue Management Processes
Bi-Weekly Status Report Template
Review project tasks, schedules, and resources and make changes or additions, as appropriate; measure and evaluate progress against the PMP with the Project Managers
Work with the Project Managers to address and resolve deviations from the PMP
Conduct regularly scheduled database initiatives status meetings
Prepare meeting agendas and minutes
Help resolve deviations from the estimated schedule
Help resolve project issues and escalate issues, as necessary
Review with staff the monthly project status, acting on issues, actions and recommendation set forth in the Bi-Weekly Status Reports
Work with the staff to identify individuals who will need to participate in the workshops and meetings, establish the schedules for these meetings, coordinate kickoff meeting location and confirm attendance.
Provide mentoring for staff
Microsoft SQL Server
Stored Procedure development
Microsoft .NET Framework common language runtime (CLR) SQL Performance and Tuning Tools
Red Gate Tools
Database tuning and transactional flow
Proposed Deliverables are to include but are not limited to the following:
Meeting agendas and minutes
Design Documentation including ERD / Data Flow / Logic Analysis
Bill of Materials for Production deployments
Database scripts that create / modify all necessary DB objects (DDL)
CLR code and build instructions to TFS
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [ Phone number blocked ] .