DBA Principal,Actimize(Database Architect, Linux)
NICE
about 16 hours ago
Pune, India
Staff+
Responsibilities
- Lead end-to-end migration of large-scale databases from Oracle and SQL Server to PostgreSQL.
- Refactor legacy SQL and stored procedures into optimized PL/pgSQL.
- Collaborate with developers to validate SQL performance and troubleshoot production bottlenecks.
- Drive performance tuning by analyzing workloads and optimizing execution plans.
- Plan database infrastructure and scaling strategies for high performance.
- Implement RBAC, SSL/TLS, and audit logging for compliance.
- Use migration tools including ora2pg and AWS SCT/DMS.
- Leverage monitoring tools such as Prometheus and Grafana.
- 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 skills (RHEL/Ubuntu).
- Hands-on experience with migration tools such as ora2pg and AWS SCT/DMS.
- Monitoring expertise with Prometheus, Grafana, and 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 like Terraform and Ansible.
- Understanding of CI/CD workflows for database changes.
- Strong analytical, communication, and presentation skills.
Benefits
- Flexible work model with 2 days in the office and 3 days remote.
- Opportunities for internal career growth across multiple roles and locations.
- Collaborative and creative work environment.
Tech Stack
AnsibleAWSAzureBashGoGoogle Cloud PlatformGrafanaHelmMicrosoft SQL ServerPostgreSQLPrometheusPythonTerraform
Categories
Data EngineeringDevOps