Overview
Are you a
Senior Database Administrator
who would like to have a positive impact for millions of people? If so, we may have an opportunity for you!
TISTA
associates enjoy above Industry Healthcare Benefits, Remote Working Options, Paid Time Off, Training/Certification opportunities, Healthcare Savings Account & Flexible Savings Account, Paid Life Insurance, Short-term & Long-term Disability, 401K Match, Tuition Reimbursement, Employee Assistance Program, Paid Holidays, Military Leave, and much more!
Responsibilities
Install/tailor new releases of and upgrades or patches to associated database management product software on various OS platforms such as Microsoft Windows, Oracle Solaris, Linux/Unix
Install and configure database software components such as SQL Server Always On, Oracle Data Guard, Golden Gate and ASM
Create and maintain database entities, including instances, databases, table spaces, and tables in support of OPSCON IO administered databases
Make changes to the structure of database meta data and support any application changes
Make recommendations of database migration path to ensure optimal performance and availability, which shall be provided to COR/VA RESOURCE LEAD(s) for review and approval prior to any migration
Review performance of databases on the open systems and mainframe platforms and provide and implement COR/VA RESOURCE LEAD(s) approved recommendations for improved performance
Write, modify, and debug database specific SQL and PL/SQL queries
Where appropriate, coordinate database administration duties with System and Network Administrators to ensure compatibility with hardware and operating systems configurations
Diagnose and correct problems that occur within databases and application interfaces
Recommend strategies for problem notification and availability reporting in database software and applications. All recommendations shall be provided to COR/VA RESOURCE LEAD(s) for approval prior to any implementation
Develop disaster recovery strategies, and execute or exercise backup/recovery, high availability and disaster recovery strategies. All recommended strategies shall be provided to COR/VA RESOURCE LEAD(s) for approval prior to any implementation
Develop Security strategies consistent with VA regulations and policies and industry best practices. All recommended strategies shall be provided to COR/VA RESOURCE LEAD(s) for approval prior to any implementation
Troubleshoot problems and take corrective action, coordinate Contractor specific technical support as necessary
Support users, other software Contractor teams, and database administrators with problems, projects, and implementations
Analyze database infrastructure to ensure compliance with VA security standards, database performance considerations, and reverse engineering of existing database environments
When assigned to VA initiatives, develop schedules and plans, communicate progress to management in both verbal and written formats, identify barriers, identify, and evaluate alternatives. The Contractor shall assist in fault isolation for database systems
When required, develop, and submit for approval Configuration Change Management Plans in accordance with OPSCON IO standards. The Contractor shall follow the change management process prescribed by the Chief, Database
Support Services when making all changes to production systems
(NEW + Added Skillset) – Advanced PowerApps Knowledge with Development and implementation with Microsoft Teams, Lists, Power BI, and Power Automate
Qualifications
Basic to intermediate knowledge of database concepts
Basic knowledge of SQL queries to access data
Simple
Inner, Left and Right Joins
Unions
Intermediate knowledge of Access
Create SQL queries using the IDE
Create SQL queries using SQL editor
Create and edit objects, (forms, buttons, drop down lists)
Attached custom VBA code to objects
Knowledge on how to use VBA coding environment
Using SQL Server database within Access
Intermediate knowledge of VBA/VB
Know basic VB/VBA coding concepts
Understand object-oriented principles and constructs in VBA and V
Basic knowledge of SQL Server – knowledge will include but not limited to
Creating users
Creating tables
Creating views
Creating SQL queries
Creating relationships through primary and foreign keys
Additional Knowledge Sets:
SFTP Concepts
Reflections For Secure IT Server (SFTP Server)
WINSCP Scripting
Basic Windows server concepts
Account creation
File permissions
Task Scheduler concepts
Education:
Bachelor's Degree in Engineering, Computer Science, Systems, Business, or related scientific /technical discipline and 5+ years' work experience
Eight (8) years of additional relevant experience may be substituted for education (13 years total)
Clearance:
The ability to pass a Tier 2/Modest Background Investigation
Location:
Department of Veteran's Affairs
(100% Onsite)
Monday - Friday (6:00 AM - 4:30 PM CST Time)
Austin Information Technology Center
Department of Veteran's Affairs
1615 Woodward St
Austin, TX 78741
United States