Cloud DBA

Job Title: (Cloud DBA)

About Kyyba:
Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond to organizational changes and technological advances.
At Kyyba, the overall well-being of our employees and their families is important to us. We are proud of our work culture which embodies our core values; incorporating value, passion, excellence, empowerment, and happiness, creates a vibrant and productive atmosphere. We empower our employees with the resources, incentives, and flexibility that they need to support a healthy, balanced, and fulfilling career by providing many valuable benefits and a balanced compensation structure combined with career development.

Job Description

REQUIRED SKILLS (Special Skill Set, Abilities, Knowledge):

• Experience working with Oracle RDS
• Experience working with one or more AWS Cloud services such as S3 storage, Managed Airflow (MWAA), Data Migration Service (DMS) in support of building data pipelines
• Experience working with a variety of backend data sources (e.g. SQL Server, Oracle, Postgres, DynamoDB, Snowflake)
• Advanced SQL coding skills and ability to translate Oracle PL SQL and Stored Procedure code to alternative SQL platforms such as Snowflake
• Familiarity with data warehouse and data mart concepts such as normalization, facts, dimensions, slowly changing dimensions
• Familiarity with Change Data Capture (CDC) concepts and implementations. Knowledge of Kafka or similar replication tools is a plus
• Understanding of common file formats such as JSON, XML, CSV
• Basic experience using scripting tools to automate tasks (e.g.: Python, Windows PowerShell, bash)
• Ability to write unit test scripts and be able to validate migrated ELT/ETL code

Preferred

• Experience configuring, managing, and troubleshooting Airflow tool. Knowledge of Airflow DAGs and concepts for managing dependent graphs and complex steps
• Knowledge of Snowflake data warehouse features such as Snowpipe streaming, cloning, time travel, role-based-access control
• Prior experience working at other large organizations, preferably state or federal government
• Business domain knowledge in the Education and Student data management area.
• Experience working with software development tools such as GitHub, Jira

Location: (Everett, MA)

Disclaimer:
Kyyba is an Equal Opportunity Employer.
Kyyba does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. Minorities / Females / Protected Veterans / Individuals with Disabilities are encouraged to apply. All employment is decided on the basis of qualifications, merit, and business need."
It is the policy of Kyyba to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. If reasonable accommodation is needed, please contact Kyyba at 248-813-9665

Rewards:
Medical, dental, vision
401k
Term life
Voluntary life and disability insurance
Optional Pre-paid legal plan
Optional Identity theft plan
Optional Medical and dependent FSA
Work-visa sponsorship
Opportunity for advancement
Long-term assignment with opportunity for hire by client

SELECT AWARDS

• An INC 5000 company for 10 years
• Corp Michigan Economic Bright Spots
• Crain's Detroit Business Top Staffing Service Companies in Detroit
• TechServe Alliance Excellence Award- IT and Engineering Staffing & Solutions
• Best of MichBusiness winner in HR Wizards & Partnerships
• Metro Detroit Elite Category: Recruitment, Selection & Orientation for 101 Best & Brightest
• 101 Best & Brightest Companies to Work for in Michigan

---