Perform modifications to the enterprise database as required to resolve problem reports and implement change request, as well as maintaining and optimizing the database for the system and utilizing the priority and severity rankings as assigned by the Product Owner for sprint planning.
Responsibilities· Provide help desk support for end users and resolve change requests for database related issues.
· Recommend and implement changes to the SAAS data model/schema.
· Ensure that software design, database design, and interfaces allow for high levels of performance, maintainability, and reliability
· Define and document logical attributes and data inter-relationships for complex data structures.
· Design and maintain relational integrity, concurrency controls, index optimization, log clean-ups, and page files.
· Develop complex SQL queries and stored procedures, triggers, and functions and indexes to ensure that they are optimized for fast execution speeds to the greatest extent possible.
· Monitor database activity and file usage. Recommend and/or implement tuning opportunities to improve system response and run times.
· Support upgrades/patches of database management system software as necessary.
· Maintain the IA posture of the database system to include monitoring and resolution of applicable IAVAs. Monitor vendor security bulletins to obtain information of potential threats and install necessary security patches to ensure ongoing database security.
· Support RMF Activities for the system to include producing supporting documentation of IA compliance.
· Assist project managers and team leads in the development of project plans required for data management and database administration activities.
· Develop and implement a data migration solution to support future system migration.
QualificationsRequired:
· BS Degree in computer science AND 5 years’ experience with Windows OS, T-SQL, SQL, Database management and performing technical documentation and/or operational system test and evaluation functions directly related to major Army Management Information System
· OR 7 years’ experience in performing the foregoing functions, of which four years of recent experience was performing technical documentation and/or operational system test and evaluation functions directly related to the SAAS system.
· Requires IT-II
· Familiar with Microsoft office suite (word, excel, power point, etc.)
Company Overview
Integral partners with federal defense, intelligence, and civilian leaders to tackle their most important challenges and deliver positive outcomes. Since our founding in 1998, we have helped clients leverage existing and emerging technologies to transform their enterprises, empower growth, drive innovation, and build sustainable success. The forward-leaning solutions we deliver are tailored to each mission with a focus on keeping our nation safe and secure.
Integral is headquartered in Tysons Corner, VA and serves clients throughout the country.
We offer a comprehensive total rewards package including paid parental leave and immediate vesting in our 401(k). Give us a try and become part of a curated group of professionals at Integral Federal!
Our package also includes:
· Medical, Dental & Vision Insurance
· Flexible Spending Accounts
· Short-Term and Long-Term Disability Insurance
· Life Insurance
· Paid Time Off & Holidays
· Earned Bonuses & Awards
· Professional Training Reimbursement
· Paid Parking
· Employee Assistance Program
Integral is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, military/veteran status, physical or mental disability, or any other protected class.
Options Apply for this job onlineApplyShareEmail this job to a friendRefer Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Share on your newsfeed Application FAQsSoftware Powered by iCIMS
www.icims.com