Apex is currently looking for a MS SQL/Postgres Database Engineer for a large government for a 6 month contract that could lead to full time opportunities. This is a hybrid role that will work 3 days onsite and 2 days remote.
Locations Available: Oklahoma City, OK
Pay will depend on experience, but sweet spot is $45-50 an hour on W2 depending on experience. Willing to negotiate if rate is close.
Perks on Resume include:
--5+ years of experience with MS SQL and/or PostGreSQL. Need to have experience actually taking care of the application (creating tables, writing queries, etc).
--BigQuery experience is preferred.
--Need to have experience with Cloud based environments
Perks of this position:
--Large enterprise company looks great on resume
--Team oriented work environment
--Hybrid flexibility and room to grow internally
Job Description
Position Essential Functions
- Lead the planning, execution, and optimization of database migration projects to cloud platforms such as Microsoft SQL Server, Azure SQL, BigQuery, and others.
- Assess current database infrastructure and identify opportunities for optimization and migration to cloud-based solutions.
- Design and implement cloud-based database solutions that meet the agency's performance, scalability, and security requirements.
- Monitor database performance and implement tuning strategies to ensure optimal performance in the cloud environment.
- Implement robust security measures and ensure compliance with regulatory requirements in cloud-based database environments.
- Develop and maintain data backup and recovery strategies to safeguard critical data in cloud databases.
- Collaborate with cross-functional teams to gather requirements and ensure successful integration of cloud databases. Document migration processes, configurations, and best practices.
- Provide training and guidance to team members on cloud database technologies and best practices for migration and management.
These job functions, responsibilities, and activities may change at any time with or without notice.
Valued Knowledge, Skills, Competencies and Abilities
Knowledge of-
- Repository/data dictionary systems
- Data security systems
- Database maintenance utilities
- Data architecture
Skills and Competencies-
Excellent communication, collaboration, and problem-solving skills.
Abilities-
- Apply data processing analysis techniques.
- Resolve and prevent database integrity problems
- Communicate effectively
- Establish and maintain effective working relationships with others.
- Perform highly independent work in the design, analysis, and maintenance of database and/or data security systems.
Minimum Qualifications
Education and Experience Requirements
Requirements include a bachelor’s degree in computer science or management information systems from an accredited college or university; a vocational or technical education course resulting in certification in computer applications equivalent to a bachelor’s degree; 5 years of database administration experience; or an equivalent combination of education and experience.
Special Skills / Preferences
- Experience in hands-on query writing
- Background in Postgres, Microsoft SQL, SSIS, Azure SQL, and BigQuery.