CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members working on mission-critical systems and projects for agencies such as the Department of Homeland Security, Internal Revenue Service, and the Office of Personnel Management. The work we do effects millions of U.S. citizens daily as they interact with the systems we build. Our best-in-class commercial solutions, modified for our customers’ bespoke mission requirements, are enabling this future every day.
The Company has experienced rapid growth over the past 3 years and recently received a strategic investment from Main Street Capital Corporation (NYSE: MAIN). In addition to our recent growth in Federal Civilian agencies, we are seeking to expand our capabilities in cloud development and footprint in national-security focused agencies within the Department of Defense and U.S. Intelligence Community.
We are currently looking for a Database Architect to join our team.
Role & Responsibilities:
- Leads and plans complex database design, development, implementation, administration, tuning, ETL, and backup and recovery for assigned project(s).
- Should be able to write up to 5000 lines of complex database code in one package.
- Must have working knowledge of more than one relational database system, such as Oracle, DB2, Sybase, Informix, Access and NOSQL such as MongoDB and others.
- Works with Team Leads, database team members, software engineers and system administrators on design, development and support issues.
- Coaches and mentors other database team members on functional and technical understanding and design and administration strategy. Job duties include requirements gathering, design and maintenance documentation, following CM processes and working with other Team members.
- This individual will install and upgrade Oracle; create and maintain development, test, and production databases; create users, tables, tablespaces, triggers, and stored procedures; develop SQL, PL/SQL, and Unix shell scripts to automate DB tasks; duplicate existing databases; perform exports and imports; troubleshoot problems; implement cold and hot backup and recovery procedures; tune for performance; estimate space needed for new or expanded databases.
- Have good understanding of architectural patterns and alignment with Enterprise Architecture and customer Vision.
- May work directly with customer representative to obtain and refine functional requirements.
- Satisfies requirements, meets agreed to completion date, and performs unit and integration tests for products developed.
- Must have good communication and team oriented skills.
- May work independently on specific projects.
Clearance Requirement- Must have Active IRS MBI
If you are looking for a fun and challenging environment with talented, motivated people to work with, CTEC is the right place for you. In addition to employee salary, we offer an array of employee benefits including:
Paid vacation & Sick leave
Health insurance coverage
Career training
Performance bonus programs
401K contribution & Employer Match
- 11 Federal Holidays
Top Skills
Similar Jobs
What you need to know about the NYC Tech Scene
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
