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 executed 100+ projects for clients ranging from small business and non-profits to Fortune 50 companies and federal, state and local agencies.
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
- 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
Requirements
Experience in logical and physical data modelsOne to three (5) years of real-world experience as a DBA or equivalentExperience with Matrix / HadoopAddressing complexities of very large databases (VLDB)Experience upgrading Matrix / Hadoop to new major releasesPrevious experience with trading systems would be highly beneficialExperience with SSIS, SSAS, SSRS, RAID, SAN, DTS, ETLExperience administering databases in a clustered environment a preferredAdditional Information
Ability to work independently with various department staff, other state, local and federal agencies to accomplish goals and meet extensive deadlinesKnowledge of current Telephony services and TechnologiesKnowledge of Avaya and / or Cisco platforms, call center features and operationsAbility to resolve technical telecommunications problems utilizing multiple vendors / contractorsAbility to communicate effectively, both verbally and in writingAbility to function under pressure and maintain composure in chaotic situation to resolve service related issuesUnderstand Call Center features; such as, Automatic Call Distributions (ACD), Call Vectors, and Vector Directory numbers (VDN)Ability to develop work and call flowsWork with multiple network platforms, such as; WAN, WLAN, Security, Voice, and VideoDisseminate information effectively to all teams and customersUnderstand a large and complex network environmentJ-18808-Ljbffr