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!
Stay Connected:
Follow us on LinkedIn for updates on this job and other exciting opportunities.
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: