Vacancy caducado!
Req ID: RQ166973Type of Requisition: RegularClearance Level Must Be Able to Obtain: NoneJob Family: Database Analysis/DesignSkills:Database Management,Database Management Systems (DBMS),Structured Query Language (SQL)Experience:10 + years of related experienceJob Description:We are GDIT. The people supporting and securing some of the most complex government, defense, and intelligence projects across the country. We are currently seeking a Senior Database Administrator to support Mainframe Database (DB2) Administration activities for the Bureau of Fiscal Service (BFS).Requirements:Candidates should have a BA/BS and 10+ years of experience, of which at least eight years must be specialized in the following duties:(Candidates with MA/MS degree can qualify with 8 years of experience, of which 6 years must be specialized experience in the duties below)(Candidates with no degree must have 13 years of experience, of which 11 years must be specialized in the duties below)CA-Datacom/DB experience is desirable.Platform Roles:
Collaborate with BFS on the initial installation and configuration of Mainframe DB2 tools in the database environments. Ensure Database services are readily available.
Collaborate with BFS on the initial installation and configuration of DB2 database environment in the private and public clouds as needed.
Ensure that data is available, protected from loss and corruption, and easily accessible as needed in the private and public cloud environments.
Management Roles
Evaluate/Test DB2 Software upgrades, bug fixes, and apply security patches as per defined BFS Policies, procedures, and change management.
Provide support for other structured and unstructured database platforms as needed. Experience with CA-Datacom/DB desirable.
Manage and maintain Mainframe DB2 DBMS Objects (e.g., Database, Tablespace, tables, index).
Create Database objects, jobs, replication scripts/definition when necessary.
Recommend/suggest DBMS architectural design when requested.
Implement approved recommendations/suggestions on DBMS design.
Support, recommend, and implement creation of views, indexes, and table extends. Implement physical Database changes in support of normal data growth.
Provide BFS with authorization and user account management Standards, procedures, and processes in compliance with defined BFS Policies and procedures.
Review and approve authorization and user account management Standards, procedures, and processes.
Perform authorization and user account management (e.g., IDs/groups/roles) in compliance with defined BFS Policies and procedures.
Provide account detail to identify type, owner, size, etc. for BFS to use to show showback/chargeback.
Provide, install, and maintain database performance, monitoring and management tools DB2 database platform.
Backup/Recovery Roles
Create and implement backup and recovery plans and procedures based on industry best practices. Provide solutions to improve cost, performance, and capability to recover.
Define Database backup and recovery requirements and approach to meet Recovery Time Objective (RTO) and Recovery Point Objective (RPO) requirements of individual application.
Manage database backup schedule according to customer requirements.
Monitor database backup success.
Perform Database restores to recover from hardware or database software problems.
Support Business Continuity testing, coordinating any resources required to support testing which are in the scope of services (including third parties).
Participate in Business Continuity testing.
Test restores from backups and test restored data.
Security Roles
Comply with defined BFS Security Standards.
Maintain database security access at database and object level.
Adhere to BFS’s IAM role-based access.
Jointly develop with BFS authorization requirements for users, roles, objects, etc., and approve Change requests.
Monitor and report user and administrator access activity.
Audit and review user activity report and report violations to BFS Security.
Monitor, audit, review and report database user and administrator activity and report violations to BFS Security.
Provide BFS with audit report as required.
Availability Roles
Manage DB2 database availability and resources.
Manage Database Space (allocated and used).
Manage Database Transaction Logs (active and inactive).
Manage and perform physical database maintenance (including running of appropriate utilities, jobs, scripts).
Manage DB2 database maintenance jobs.
Monitor size of the physical database objects.
Perform database object reorganization to improve performance, reclaim space etc.
Plan and execute database data loads/exports/imports as needed.
Create, test, and report results of component recovery plans.
Capacity Planning/Performance Roles
Provide forward looking business information to support capacity and performance planning for the PaaS environment based on consumption.
Conduct Database Capacity and Performance Planning (e.g., objectives, growth expectations, trends)
Monitor and manage databases for performance and capacity requirements.
Plan and implement physical DB2 DBMS performance improvements (e.g., resize logs, modify DB2 configuration, modify physical layout, etc.) to meet objectives.
Monitor and Analyze SQL Query performance.
Perform database performance tuning as required
WHAT GDIT CAN OFFER YOU
Full-flex work week
401K with company match
Customizable health benefits packages
Collaborative teams of highly motivated critical thinkers and innovators
Internal mobility team dedicated to helping you own your career
Rewards program for high-performing employees
GDIT CAREERSOpportunity OwnedOur benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match.To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees.To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available.We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nation’s most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real.GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.
Vacancy caducado!