Job description

Job Title: Database Engineer - Matrix/Hadoop Duration: 3 Years contract Location: Reston, VA Job Responsibilities • Review and Certify new Versions • Review and Certify new patches • Review and Certify new Unix platform Client versions • Review and Certify new desktop client versions • Develop and Build Blade logic deployment package for the new Versions • Work with Desktop Engineering team to design, build and package the rollout of new version clients • Review with Information Security and Architecture team for security clearance of the new version to be rolled out in client. • Design, plan and develop process to upgrade from current version to new Version • Design and provide the plan for migrations to different environment, server and platform • Design and provide solution for Replication , High Availability and Disaster Recovery • Enhance security policies, data security controls and processes for compliance • Build and enhance the operational guideline for management • Design and provide automation scripts for deployments • Design and develop Bladelogic Database Automation Package to deploy and rollback database software patches • Publish quarterly report on Databases versions and patches to Audit Team • Work with Retirement Delivery Scheduling (RDS) team to retire apps, hardware with upgrades and out of support products. Reclaim or reuse the license costs • Interact with the product team, understand business requirements and design technical solutions • Develop new programs, modify existing programs, and prepare functional specifications documents • Seek and recommend opportunities for process improvement • Analyze accuracy of project results • Perform code review and follow change management process • Troubleshoot and debug issues • Understand the functionality of existing applications and how to modify per requirements • Manage the installation, configuration and administration of database management systems, utilities, and tools. • Provide support for production, QA, and development database environments. • Daily monitoring of database backups, jobs, logs, space, utilization and other parameters for all database environments. • On a rotating schedule, provide night / weekend on-call support for mission critical databases. Review all daily on-call reports as needed. • Perform tuning to ensure database optimization, review preliminary database designs, data analysis, and creation of new databases as needed. • Write coding/packages as needed to assist IT units. • Work with users to identify challenges and opportunities for improvement. • Deploy database patches and upgrades. • Deploy changes to production as requested. • Develop work plans for assigned projects. • Create documentation of database specifications and processes. • Create / implement database patching strategy • Install and manage Sybase IQ and Sybase ASE databases • Translate requirements into database specifications. • Assist in training new associates both within department and within business units. • Complete all required documentation to meet department standards. • Adhere and maintain a positive working relationship with all the enterprise departments to optimize working relationships and communication. • Tier-3 support requests to identify database issues and resolve issues with database versions and patches • Experience in logical and physical data models • Adhere to privacy and confidential and proprietary company policies and procedures (i.e. HIPAA). • One to three (5) years of real-world experience as a DBA or equivalent • Experience with Matrix/Hadoop • Addressing complexities of very large databases (VLDB) • Experience upgrading Matrix/Hadoopto to new major releases • Previous experience with trading systems would be highly beneficial. • Experience with SSIS, SSAS, SSRS, RAID, SAN, DTS, ETL. • Experience administering databases in a clustered environment a preferred. • Ability to work independently with various department staff, other state, local and federal agencies to accomplish goals and meet extensive deadlines. • Knowledge of current Telephony services and Technologies. • Knowledge of Avaya and/or Cisco platforms, call center features and operations. • Ability to resolve technical telecommunications problems utilizing multiple vendors/contractors. • Ability to communicate effectively, both verbally and in writing. • Ability to function under pressure and maintain composure in chaotic situation to resolve service related issues. • Understand Call Center features; such as, Automatic Call Distributions (ACD), Call Vectors, and Vector Directory numbers (VDN). • Ability to develop work and call flows • Excellent customer service skills • Work with multiple network platforms, such as; WAN, WLAN, Security, Voice, and Video • Disseminate information effectively to all teams and customers • Understand a large and complex network environment

Requirements

Must-haves

Job Title: Database Engineer - Matrix/Hadoop
Duration: 3 Years contract
Location: Reston, VA
Review and Certify new Versions
Review and Certify new patches
Review and Certify new Unix platform Client versions
Review and Certify new desktop client versions
Develop and Build Blade logic deployment package for the new Versions
Work with Desktop Engineering team to design, build and package the rollout of new version clients
Review with Information Security and Architecture team for security clearance of the new version to be rolled out in client.
Design, plan and develop process to upgrade from current version to new Version
Design and provide the plan for migrations to different environment, server and platform
Design and provide solution for Replication , High Availability and Disaster Recovery
Enhance security policies, data security controls and processes for compliance
Build and enhance the operational guideline for management
Design and provide automation scripts for deployments
Design and develop Bladelogic Database Automation Package to deploy and rollback database software patches
Publish quarterly report on Databases versions and patches to Audit Team
Work with Retirement Delivery Scheduling (RDS) team to retire apps, hardware with upgrades and out of support products. Reclaim or reuse the license costs
Interact with the product team, understand business requirements and design technical solutions
Develop new programs, modify existing programs, and prepare functional specifications documents
Seek and recommend opportunities for process improvement
Analyze accuracy of project results

Nice-to-haves

Experience administering databases in a clustered environment a preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Platform: smartrecruiters
Effort: medium

Benefits

Benefits detected in the listing.

Pto