Database Engineer- Hadoop/Matrix

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