What are the responsibilities and job description for the Senior Database Administrator - Oracle + SQL Server {W} position at ARKA Group, LP?
ARKA Group L.P. (“ARKA”) is an advanced technologies company serving the U.S. military, intelligence community, and commercial space industry delivering next-generation solutions to support the national security space enterprise. Built on more than six decades of excellence, ARKA brings modern approaches and a culture of innovation to the challenges of today.
Join the ARKA team to learn how Beyond Begins Here. Discover your next career opportunity now!
Position Overview
In this position, you will be part of a talented and growing IT team and take responsibility for a wide range of assignments supporting on-premises and hosted data. In doing so, you’ll have the opportunity to apply your expert level knowledge of database architecture, standards, programming, and optimization techniques. You will build database configurations, maintain data flows and related processes, optimize servers and databases, increase automation, usability, and create technical documentation. This will require use of complex database security techniques, backup, restoration, migration strategies, risk management, and disaster recovery. This opportunity will afford the successful candidate to influence, grow and evolve with the organization as we transform into a new corporation.
Responsibilities
Located in beautiful Fairfield County, Danbury offers a diverse economy, wonderful parks, cultural attractions, an impressive mix of private and public educational institutions and a vibrant arts scene. Our facility is nestled among a remarkable selection of communities to call home all with varying price points to fit many different budgets. We’re close to New York City, Boston, and other major cities – great for day trips and weekend getaways. Our lovely seasons along with award-winning institutions, colleges, cultural events, and a genuine sense of community brings a diverse population to the beautiful state of Connecticut!
What We Offer
This job operates in a professional office environment. While performing the duties of this job, the employee routinely is required to use hands to keyboard, communicate, listen to, and interpret instructions and remain stationary for extended periods of the time. This would require the ability to move around the campus and occasionally move/lift items weighing up to 25 lbs. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.
Applicants are invited to apply for a reasonable accommodation to perform the essential duties of the job. To apply, send a request to staffing@arka.org or contact 203-797-5000 and press 2 for Human Resources.
ITC & Security Clearance Requirements
This position requires the ability to obtain and maintain a U.S. Government Security Clearance.
This position also requires U.S. citizenship in support of contract requirements. Additionally, if you are a dual citizen (a citizen of the U.S. and another country), the Company must obtain approval for you to have access to the information required for this position. You will not be able to begin employment until such approval is obtained and this may take several months.
Visa Restrictions
No visa sponsorship is available for this position.
Pre-employment Screenings
Employment with any ARKA companies in the U.S. is contingent upon satisfactory completion of several pre-employment requirements to include a credit check, background check, and drug screen.
Join the ARKA team to learn how Beyond Begins Here. Discover your next career opportunity now!
Position Overview
In this position, you will be part of a talented and growing IT team and take responsibility for a wide range of assignments supporting on-premises and hosted data. In doing so, you’ll have the opportunity to apply your expert level knowledge of database architecture, standards, programming, and optimization techniques. You will build database configurations, maintain data flows and related processes, optimize servers and databases, increase automation, usability, and create technical documentation. This will require use of complex database security techniques, backup, restoration, migration strategies, risk management, and disaster recovery. This opportunity will afford the successful candidate to influence, grow and evolve with the organization as we transform into a new corporation.
Responsibilities
- Installing and regularly upgrading Oracle and SQL Server
- Create and manage database tablespaces
- Database user account creation and management
- Database and database infrastructure security configurations
- Support security teams with required security configurations, justifications, and Information assurance vulnerability management (IAVM) tasks
- Manage Oracle and SQL Server Database instances on Linux and Windows operating systems
- Expertise with Windows OS configuration and management
- Provide full system administration and database administration support for the SQL Server and Oracle environment
- Provide support for development, test and production Oracle/SQL Server enterprise relational database management systems
- Minimum experience 5 years performing in an Oracle 19c and SQL Server 2019 DBA role
- Experience administering Business Management applications and knowledge of Business application architecture
- Knowledge of standard integration platforms and REST APIs
- Strong knowledge of database roles/security best practices
- Problem solving plus analytical skills troubleshooting complex database issues
- Demonstrated experience in the following:
- Scripting Experience – (ie:Shell, Bash, Python, PowerShell.)
- Application servers (ie: RedHat JBOSS, Apache, IIS)
- database/application performance tuning in Oracle and SQL Server
- Reading execution plans, query store, extended events
- Backup and Recovery Tools: RMAN, pg_dump, veeam
- TSQL Scripts and writing complex queries
- Working on reorg/rebuild indexes and fragmentation issues
- GUI Tools – SSMS, SQL Developer, Toad
- SQL Tools – SSIS SSRS
- Experience working in a DoD environment with associated clearances is preferred
- Experience with automated system configuration
- Experience with PostgreSQL
- Knowledge of Data Warehouse concepts
Located in beautiful Fairfield County, Danbury offers a diverse economy, wonderful parks, cultural attractions, an impressive mix of private and public educational institutions and a vibrant arts scene. Our facility is nestled among a remarkable selection of communities to call home all with varying price points to fit many different budgets. We’re close to New York City, Boston, and other major cities – great for day trips and weekend getaways. Our lovely seasons along with award-winning institutions, colleges, cultural events, and a genuine sense of community brings a diverse population to the beautiful state of Connecticut!
What We Offer
- Comprehensive medical/vision/dental insurance packages
- Company contributions to qualified HSA accounts
- 401k retirement plan with industry leading company contributions
- 3 weeks of vacation accrual per year plus time off for sick leave and unscheduled life events
- 13 paid holidays
- Upfront tuition assistance for approved degree programs
- Annual bonus program based on company and employee performance
- Company paid life insurance, AD&D, Short-Term and Long-Term disability insurance
- 4 weeks paid Parental Leave
- Employee assistance program (EAP)
This job operates in a professional office environment. While performing the duties of this job, the employee routinely is required to use hands to keyboard, communicate, listen to, and interpret instructions and remain stationary for extended periods of the time. This would require the ability to move around the campus and occasionally move/lift items weighing up to 25 lbs. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the job.
Applicants are invited to apply for a reasonable accommodation to perform the essential duties of the job. To apply, send a request to staffing@arka.org or contact 203-797-5000 and press 2 for Human Resources.
ITC & Security Clearance Requirements
This position requires the ability to obtain and maintain a U.S. Government Security Clearance.
This position also requires U.S. citizenship in support of contract requirements. Additionally, if you are a dual citizen (a citizen of the U.S. and another country), the Company must obtain approval for you to have access to the information required for this position. You will not be able to begin employment until such approval is obtained and this may take several months.
Visa Restrictions
No visa sponsorship is available for this position.
Pre-employment Screenings
Employment with any ARKA companies in the U.S. is contingent upon satisfactory completion of several pre-employment requirements to include a credit check, background check, and drug screen.