Loading...
LeadFull-timePythonAWSGCPAzureTerraformPostgreSQLCI/CDGitGoAI
Salary Range
$24,225 - $32,775 /year
This salary is estimated based on similar roles. The actual salary may vary.
About the Role
NICE Actimize is seeking a seasoned Database Architect to lead database modernization and optimization efforts. This role requires expertise in PostgreSQL with heritage in Oracle and SQL Server, focusing on high performance and strategic consulting.
Key Responsibilities
- →Lead end-to-end migration of large-scale databases from Oracle and SQL Server to PostgreSQL
- →Refactor legacy SQL, stored procedures, triggers, and functions into optimized PL/pgSQL
- →Collaborate with developers to review code, validate SQL performance, and troubleshoot bottlenecks
- →Drive performance tuning by analyzing workloads, optimizing execution plans, and adjusting configurations
- →Demonstrate expertise in High Availability architecture, backup & recovery, and Postgres internals
- →Plan database infrastructure, capacity, and scaling strategies
- →Implement RBAC, SSL/TLS, and audit logging for compliance
- →Use migration tools including ora2pg, AWS SCT/DMS, or custom ETL frameworks
- →Leverage monitoring tools such as Prometheus, Grafana, pg_stat_statements, and pgBadger
- →Utilize Bash, Python, or Go for automation
- →Work with cloud-managed PostgreSQL on AWS, GCP, or Azure
Requirements
- ✓Expert-level PostgreSQL experience (versions 12–17)
- ✓Strong proficiency in Oracle (SQL + PL/SQL) and SQL Server (T-SQL)
- ✓Advanced Linux Administration (RHEL/Ubuntu)
- ✓Hands-on experience with migration tools such as ora2pg, AWS SCT/DMS
- ✓Monitoring expertise with Prometheus, Grafana, pg_stat_statements, pgBadger
- ✓Automation skills in Bash, Python, or Go
- ✓Cloud experience with AWS/GCP/Azure-managed PostgreSQL services
- ✓Experience with HA/DR, replication, and scaling strategies
- ✓Knowledge of Infrastructure-as-Code tools (Terraform, Ansible, Helm)
- ✓Understanding CI/CD workflows for database changes
- ✓Strong analytical, communication, and presentation skills
- ✓Mentorship experience and ability to upskill development teams
- ✓Strategic thinking with ability to translate business needs into scalable models
- ✓Proven record managing high-pressure production outages and conducting RCA
- ✓Strong ownership mindset and thought leadership
Benefits
- ★Hybrid work model (2 days office, 3 days remote)
- ★Career growth opportunities across multiple roles, disciplines, and locations
Free to sign up. Takes 30 seconds.
