NorthITE · 7 hours ago
Need PostgreSQL DBA/SME
Chicago, IL
Contract
Hybrid
Senior Level, Lead/Staff
10+ years expNorthITE is seeking an Expert-Level PostgreSQL Database Administrator (DBA) to lead large-scale database modernization and migration initiatives across hybrid and multi-cloud environments. The role requires deep PostgreSQL expertise and the ability to architect and execute complex multi-cloud transformation projects, primarily focusing on Google Cloud.
Information Technology & Services
Hiring Manager
Ramakrishna Bandari (Joe)
Responsibilities
Act as the PostgreSQL Subject Matter Expert (SME) across the organization, leading architecture, performance tuning, automation, and high-availability strategies
Design, implement, and manage PostgreSQL clusters in Google Cloud (AlloyDB, Cloud SQL)
Configure and support replication, HA/DR (streaming, logical, Patroni), backup, recovery, and failover mechanisms
Automate key administrative tasks using Python, Bash, Ansible, Terraform, and integrate with CI/CD pipelines for continuous delivery and change management
Implement and integrate with Ensono and Client proactive monitoring and observability frameworks (Google/AWS-native tools, Data Dog, BMC) to ensure high performance and uptime
Lead end-to-end migration efforts from Oracle to PostgreSQL/AlloyDB — including assessment, schema conversion, data transformation, validation, and tuning
Leverage tools like Ora2Pg, AWS SCT/DMS, and custom migration frameworks to automate and streamline migration tasks
Refactor PL/SQL to PL/pgSQL, optimize data models, and ensure application compatibility in the target PostgreSQL environments
Develop and maintain migration playbooks, cutover procedures, and validation checklists to standardize enterprise migration efforts
Collaborate with Client application and internal infrastructure teams to coordinate testing, downtime planning, and post-migration performance validation
Collaborate with Clients to Architect and support Google Cloud Platform database solutions — including AlloyDB, Cloud SQL Cloud Compute, and BigQuery integration
Define Infrastructure as Code (IaC) standards using Terraform and Ansible for repeatable, secure provisioning and configuration
Partner with Client and Ensono cloud, security, and networking teams to ensure compliance with IAM, encryption, audit logging, and retention policies
Drive capacity planning, cost optimization, and performance benchmarking across all supported cloud environments for the Client
Provide technical leadership and direction for complex database migration and modernization projects
Mentor DBA teams, review designs, and establish technical best practices for PostgreSQL, AlloyDB, and cloud databases
Contribute to strategic planning for enterprise database modernization and automation initiatives
Maintain comprehensive documentation, runbooks, and operational standards for the DBA organization
Qualification
Required
10+ years of progressive database administration experience, with 5+ years of deep hands-on PostgreSQL experience in production environments
Proven success leading Oracle-to-PostgreSQL or Oracle-to-AlloyDB migration programs in enterprise-scale settings
Expertise in Google Cloud Platform (AlloyDB, Cloud SQL, IAM, VPC, GCS) with working experience in AWS RDS/Aurora PostgreSQL
Proficiency in SQL optimization, query tuning, indexing, and storage architecture
Solid foundation in Linux system administration, network troubleshooting, and security compliance frameworks (GDPR, HIPAA, SOC2)
Excellent analytical and problem-solving skills; proven ability to manage complex technical initiatives across teams and time zones
Preferred
Google Cloud Certified – Professional Database Engineer or AlloyDB Specialist
PostgreSQL Certification (EDB, AWS, or Google Cloud)
ITIL Foundation, PMP, or Agile/DevOps certification preferred
Strong understanding of Oracle Database administration (11g–19c), PL/SQL, and Data Guard/RMAN principles
Experience with Oracle GoldenGate for replication and data synchronization during migration and hybrid coexistence
Ability to design, test, and optimize replication pipelines and cutover strategies using GoldenGate and PostgreSQL logical replication
Familiarity with Oracle licensing, cost management, and performance optimization a strong plus
Company
NorthITE
Northite is a dynamic and innovative technology solutions company that empowers businesses with cutting-edge services.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase