Database Engineer- Hadoop​/Matrix

Techno Gen, Inc. (formerly known as SYSCOM Technologies) is a Proven Leader in providing full IT Services, Software Development and Solutions for 12+ years. Techno Gen 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 executed 100+ projects for clients ranging from small business and non-profits to Fortune 50 companies and federal, state and local agencies.

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 Blade logic 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
• 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
• 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
• 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/Hadoop 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
• 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…