Database Engineer- Hadoop/Matrix

Company Description

TechnoGen, Inc. (formerly known as SYSCOM Technologies) is a Proven Leader in providing full IT Services, Software Development and Solutions for 12+ years.TechnoGen is a Small & Woman Owned Minority Business with GSA Advantage Certification. We have offices in VA,MD & Offshore development centers in India.We have successfully excuted 100+ projects for clients ranging from small business and non-profits to Fortune 50 companies and federal, state and local agencies.

TechnoGen leadership has experience guiding highly skilled and certified professionals delivering end to end IT and Business consulting services projects in public and commercial sectors across the globe. 

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.

Additional Information

• 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