Ms SQL Database Administrator

**Position: SQL Database/Oracle Administrator**

**Position Overview**:
**Position Overview**

**Company Overview**:
Fortive acquired Intelex in 2019.

**Responsibilities and Deliverables**

**Database Administration & Architecture**
- Design, implement, and optimize databases across **MS SQL Server, Oracle, and PostgreSQL** environments.
- Define and maintain best practices for **schema design, indexing strategies, and query optimization**.

**Performance Tuning & Scalability**
- Conduct proactive **query tuning, execution plan analysis, and indexing strategies** to optimize database performance.
- Monitor, troubleshoot, and resolve performance bottlenecks across **MS SQL Server, Oracle, and PostgreSQL**.
- Implement **partitioning, replication, and caching** to improve data access and efficiency.

**High Availability, Replication & Disaster Recovery**
- Implement **HA/DR solutions** for all supported databases, including **MS Clustering, Oracle Data Guard, PostgreSQL Streaming Replication, and AlwaysOn Availability Groups**.
- Perform **capacity planning** and ensure proper **backup and recovery strategies** are in place.
- Automate and test **failover and recovery** processes to minimize downtime.

**Security & Compliance**
- Implement **role-based access control (RBAC), encryption, auditing, and compliance policies** across all database environments.
- Ensure adherence to **SOC 2, ISO 27001, GDPR, and HIPAA** security standards.
- Collaborate with security teams to identify and mitigate vulnerabilities.

**DevOps, CI/CD, & Automation**
- Integrate database changes into **CI/CD pipelines**, ensuring **automated schema migrations and rollbacks**.
- Use **Terraform or other IaC tools** for database provisioning and configuration management.
- Automate routine maintenance tasks, monitoring, and alerting using** New Relic and PagerDuty or similar**.

**Cloud & Data Technologies**
- Manage **cloud-based database solutions** such as **Azure SQL, Amazon RDS, Aurora, Oracle Cloud, and PostgreSQL on AWS/Azure**.
- Work with **NoSQL solutions like MongoDB** when needed.
- Support **data warehousing and analytics solutions** (e.g., Snowflake, Redshift, SSAS).

**Incident Response & On-Call Support**
- Provide** on-call support** for database-related production incidents on a rotational basis.
- Conduct **root cause analysis** and implement long-term fixes for database-related issues.

**Organizational Alignment**

This is a highly collaborative role requiring close interactions with:

- **DevOps & SRE teams** to improve database scalability and monitoring.
- **Developers** to ensure efficient database designs and optimize queries.
- **Cloud & Security teams** to maintain compliance and security best practices.

**Qualifications & Skills** **Required**:

- **7-10 years** of experience managing **Oracle**, **MS SQL Server, and PostgreSQL** in enterprise environments.
- Expertise in **database performance tuning, query optimization, and execution plan analysis**.
- Ability to implement **replication, clustering, and HA, AlwaysOn, and cloud technologies**.
- Hands-on experience with **cloud databases in AWS or Azure** (RDS, Azure SQL, Oracle Cloud, etc.).
- Solid understanding with **backup strategies, disaster recovery concepts, and failover testing**.
- Proficiency in **T-SQL, PL/SQL, and PostgreSQL SQL scripting**.
- Basic scripting understanding and exposure to **PowerShell, Python, or Bash**.

**Preferred**:

- Experience with cloud-based databases (e.g., Azure SQL, Oracle Cloud).
- Exposure to high availability features like Always On or Oracle RAC/Data Guard.
- Basic scripting skills in PowerShell or Bash.
- Relevant certifications (e.g., Oracle OCA, Microsoft Azure Database Fundamentals).
- Azure Database Administrator Associate, or AWS Certified Database - Specialty.

**Education & Other Requirements**
- Bachelor's degree in **Computer Science, Data Engineering, or equivalent experience**.
- This role requires a **satisfactory Criminal Background Check and Public Safety Verification**.

**Why Join Intelex Technologies?**
- **Work with cutting-edge database technologies** in a fast-paced, DevOps-driven environment.
- **Flexible remote work options** and opportunities for professional growth.
- **Collaborate with top-tier cloud, DevOps, and security experts** to drive innovation.

**Fortive Corporation Overview**

We are a global industrial technology innovator with a startup spirit. Our forward-looking companies lead the way in software-powered workflow solutions, data-driven intelligence, AI-powered automation, and other disruptive technologies. We’re a force for progress, working alongside our customers and partners to solve challenges on a global scale, from workplace safety in the most demanding conditions to groundbreaking sustainability solutions.

We are a diverse team 17,000 strong, united by a dynamic, inclusive culture and energized by limitless learning and growth. We use the proven Fortive Business