Database Engineer

Apex Systems Hartford , CT 06183

Posted 2 months ago

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 ] .

PROJECT OVERVIEW

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

Required Skills/Experience

  • 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

Deliverables:

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

EEO Employer

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 ] .


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Database Cloud Engineer (Remote)

The Hartford

Posted 3 months ago

VIEW JOBS 1/25/2020 12:00:00 AM 2020-04-24T00:00 Ready to grow your career leveraging the latest Database and Middleware technologies in the Cloud?Join a fast-paced and talented agile engineering team to build the next generation of The Hartford's database platforms. We use the latest open source technologies, software engineering practices and delivery methodologies and are passionate about technology and building well architected and innovative solutions for the business. We have rapidly changing Enterprise environment that includes many platforms, computing environments, vendor packages, in-house applications, and highly challenging application projects.This cutting edge and forward focused team presents the opportunity for innovative thinking, autonomy and visibility as we focus on bringing in the newest and best of breed technology capabilities to solve Business Problems.The position calls for an individual possessing wide industry experience and strong knowledge base in a broad range of Database Platform technologies deployed on mixed Cloud Environments. The primary function of this person will be to help enable business agility using a wide range of DB solutions that offer the best technical solution at the most optimal cost in Cloud environments.What's in it for you? * Collaboration with a high-performing, forward-focused team and stakeholders * Opportunity to learn and leverage the latest database technologies and software engineering tools/practices * Opportunity to set Enterprise standards and guidelines for optimal use of technology in Hartford adopted Cloud Services * Frequent mentoring and feedback Technologies * Cloud platforms like AWS, Azure & IBM * AWS Cloud Databases - Postgres RDS & Aurora, MySQL RDS, Dynamo, Snowflake * AWS Services - EC2, S3, EMR, IAM, KMS, Cloud Watch, DMS, Lambda * Azure Cloud Databases - SQL Managed Instance * Operating Systems - Linux, Windows * Git, Ansible, Rightscale, Nexus, Jenkins, Nexus, Maven, Containers * Open Source Databases - PostgreSQL, MySQL * SQL Server RDBMS 2012, 2016, 2017 * Oracle RDBMS 12c, 18c, 19c * NOSQL Databases Tools * AWS: AWS CLI, AWS SDKs * Azure: Azure CLI, Powershell * SQL Server: SQL Server Management Studio, SSDT, Visual Studio, Powershell, T-SQL, * Oracle: Toad, Putty, PL/SQL * RightScale: RightScale CATs, RightScript * Scripting: Unix, Windows * Computer Science undergraduate with 10 years in a technology role with a minimum of three years working on Platform architecture and strategy * Excellent oral and written communication skills * Strong business acumen. * Exceptional critical thinking and problem solving skills. * Ability to communicate technically as well as non-technically across various levels of business * Able to influence diverse teams and building strong business relationships * Self-starter. Able to balance multiple demands from multiple customers. * Solid planning and organization skills. Establish priorities, anticipate problems, determine completion dates, manage time effectively; use the services of others effectively. * Experience in a highly regulated environment with demonstrated success working with internal and external compliance partners * Ability to manage the design, development, deployment, and technical quality of large enterprise solutions that span multiple technologies and disciplines. * Deep IT Infrastructure expertise (cloud, compute, middleware, Database, networking). * Broad exposure to enterprise database design and administration. * Superior Capability to understand new technology, go deep into capabilities and make a recommendation on adoption and best use cases. * Conduct proof of concepts; develop Enterprise standards and best practices; put together Engineering design solutions that can be deployed using automation. * Understanding of open source tools that can and should be leveraged to solve problems * Knowledge of best practices and IT operations in an always-up, always-available service * Familiarity with traditional Database technologies such as Oracle & SQL server * Hands-on experience with AWS services. Certification preferred. * Hands-on experience with Azure services preferred, but not required. Equal Opportunity Employer/ Females/ Minorities/ Veterans/ Disability/ Sexual Orientation/ Gender Identity or Expression/ Religion/ Age Must be authorized to work in the U.S. without company sponsorship The Hartford Hartford CT

Database Engineer

Apex Systems