2024-7323_Systems Engineer - Level III

Arch Global Services offers competitive pay and a comprehensive benefits package. Additionally, Arch is committed to helping its associates create what’s next by providing access to a variety of programs supporting your professional development and a culture that encourages innovation, collaboration and professional growth. We seek talent that thinks innovatively, values collaboration and will go the extra mile to serve our customers and develop our company. We also have a little fun along the way, check out our Holiday Party.

We are looking for a senior level Infrastructure Database Administrator who will be part of the Infrastructure Operations team managing and maintaining the server and database infrastructure. Including but not limited to operational projects of migration and optimization of databases on prem as well as on the cloud.

Responsibilities:

• SQL Server upgrades/migrations
• Performance Tuning – review critical databases and improve the performance including indexing, SQL tuning
• Database Jobs Schedules – migrate all database jobs to JAMS centralized enterprise scheduling
• Monitoring and Alerting – setup database monitoring, adjust thresholds and alerting
• Database health checks
• Database Re-orgs
• New product/application support activities
• Database automation – automating database tasks
• Database DevOps – identify tools to include database deployments through CI/CD pipelines
• Database version control – ensure the database across all the environments are in synch
• Disaster Recovery – Test and Validate database recovery mechanisms and support DR testing
• Creation and management of databases in on-prem servers, cloud servers and cloud manage instances.
• Documentation
• On-Call rotation
• Knowledge of SQL Server, Oracle, Postgress, MongoDB

Qualification:

• SQL Server Always On
• Deep Understanding of Triggers
• Deep Understanding of Full Text indexes
• Oracle Database
• SQL Managed Instance in Azure
• Database tuning & Optimizing – Index Tuning (Clustered and non-clustered) – Use of database tuning tools SQL Tracing, SolarWinds DPA, Spotlight On SQL, RedGate, etc…
• Database design 3rn Normal for traditional databases
• Data Transformation Expertise using SSIS, Python
• Database design for NOSQL databases – MongoDB
• MongoDB shards
• Document DB design
• Azure Cloud Administration
• JSON, XML
• Expertise with ELK Stack – Elastic Search
• DEVOPS – CI/CD, Jenkins, Bitbucket, GitHub
• At least 7 years’ experience as a DBA
• 5 years’ experience as a SQL developer
• 2+ years of MongoDB experience

• 4-year IT degree or equivalent