Senior Software Engineer - Database
What you do
In this role, you will be part of Cloud product development team to design, optimize, migrate and manage large-scale database platforms across cloud environments for retail products– TrueVUE / Shrink Analyzer / ShopperTrak Analytics deployed on Google Cloud Platform.
You will work within a multi-disciplined engineering team consisting of Java engineers, Mobile development engineers, Web UI engineers and Software Architects focusing on applied research and new technology innovations to provide new and improved products and solutions for our customers.
The role is ideal for someone who combines strong database Design and administration expertise with cloud architecture, performance engineering and migration leadership capabilities.
How you do it
- Architectural understanding of any commercial RDBMS (Oracle,Postgres,SQLServer). (Preferably Postgres) and any one NoSql DB (preferably - Mongo DB)
- Design, implement and maintain highly available, scalable and secure database solutions across cloud platforms.
- Perform advance SQL query optimization and database performance tuning.
- Analyze execution plans, indexing strategies, partitioning and workload patterns to improve database performance.
- Implement backup, recovery, disaster recovery and business continuity solutions.
- Design and maintain database monitoring, alerting and observability frameworks.
- Collaborate with architects, developers, SREs and Devops teams to ensure database reliability and performance.
- Automate operational tasks using scripting and Infrastructure as Code (IaC) practices.
- Establish database governance, security standards and compliance controls.
- Mentor junior engineers and contribute to database best practices.
What we look for
- BE (ECE/ ETC/CSE/ISE) is required.
- 5 to 7 years of experience in database design and management.
- 2 to 3 years of experience working on Cloud managed databases.
- Strong expertise with one or more SQL databases: PostgreSQL, Microsoft SQL Server, Oracle Database (Preferably PostgreSQL).
- Design and Development of Database with expertise in any one of TSQL/PL-SQL/pgSQL
- Development and management expertise on any one NoSQL database (preferably mongo db)
- Performance Engineering:
- Query tuning and optimization.
- Database profiling using (pg_stat/dmv/v$ views) and troubleshooting.
- Index design and optimization.
- Transaction management strategies.
- Partitioning, Clustering and sharding strategies.
- Capacity planning and workload analysis.
- Expertise on Database Recovery and Replication
- Backup/restore methods with Transaction Logs/Wal files and Post-restore Database operations
- Physical and logical replication setup
- Cloud & Infrastructure expertise:
- Hands-on experience with cloud-managed database offerings.
- Experience in Kubernetes-based database deployments and containerized workloads.
- Familiarity with Infrastructure as Code tools such as Terraform, Ansible.
- Migration & Modernization:
- Database migration planning and execution.
- User mgmt,Schema conversion and data migration.
- Zero /low downtime migration techniques.
- Cross-platform migration experience.
- Automation & Monitoring:
- Scripting using Python, Shell or PowerShell.
- Experience with monitoring tools such as: Prometheus, Grafana, Datadog.
- Must have a desire to achieve excellence in customer satisfaction, process and product quality and reliability.
- Strong understanding of different software development life cycles (Agile) and contemporary software quality assurance processes and automated tools.
- Must have experience in managing and working with distributed team members.
- Must be extremely detail-oriented with respect to documentation and communication
Specialized Skills:
Strong communication, interpersonal, problem solving and presentation skills Able to work independently or in a team environment Able to take ownership and work on project timelines Self-motivated, takes initiative to resolve issues Ability to solve problems through analysis of a situation where there are a variety of variables
Johnson Controls is an equal employment opportunity and affirmative action employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, status as a qualified individual with a disability, or any other characteristic protected by law. For more information, please view EEO is the Law. If you are an individual with a disability and you require accommodation during the application process, please visit www.johnsoncontrols.com/tomorrowneedsyou.
Skills Required
- Bachelor of Engineering (ECE/ETC/CSE/ISE)
- 5 to 7 years experience in database design and management
- 2 to 3 years experience working on cloud managed databases
- Expertise with SQL databases: PostgreSQL, Microsoft SQL Server, Oracle Database (Preferably PostgreSQL)
- Design and development experience with T-SQL, PL-SQL or pgSQL
- Development and management experience with a NoSQL database (preferably MongoDB)
- Advanced SQL query optimization and database performance tuning
- Database profiling and troubleshooting using pg_stat / DMV / v$ views
- Index design and optimization
- Transaction management strategies
- Partitioning, clustering and sharding strategies
- Capacity planning and workload analysis
- Database recovery and replication: backup/restore, WAL/transaction log handling, physical and logical replication
- Hands-on experience with cloud-managed database offerings (GCP)
- Experience with Kubernetes-based database deployments and containerized workloads
- Familiarity with Infrastructure as Code tools such as Terraform and Ansible
- Database migration planning and execution, schema conversion, user management, cross-platform migration and zero/low downtime techniques
- Scripting/automation using Python, Shell or PowerShell
- Experience with monitoring and observability tools such as Prometheus, Grafana, Datadog
- Strong understanding of Agile SDLC and software quality assurance processes
- Experience managing and working with distributed team members
- Detail-oriented with strong documentation and communication skills
Johnson Controls Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Johnson Controls and has not been reviewed or approved by Johnson Controls.
-
Retirement Support — Retirement support is positioned as a meaningful part of the package through employer 401(k) matching, repeatedly framed as a strong pillar of the overall rewards mix. The matching contribution is described with specific match levels in multiple places, reinforcing perceived value for long-term saving.
-
Leave & Time Off Breadth — Time off is presented as comparatively robust, with multiple paid holiday categories, vacation time, and sick time described as generous or “amazing” in places. Paid time off breadth appears to be a consistent contributor to total rewards attractiveness beyond base pay.
-
Flexible Benefits — Benefits are described as broad and customizable, spanning standard medical/dental/vision plus optional add-ons like pet insurance, identity protection, and legal support. Tuition reimbursement is repeatedly highlighted as a high-value option supporting professional development.
Johnson Controls Insights
What We Do
At Johnson Controls, we transform the environments where people live, work, learn and play. From optimizing building performance to improving safety and enhancing comfort, we drive the outcomes that matter most. Dedicated to protecting the environment, we deliver our promise in industries such as healthcare, education, data centers and manufacturing. With a global team of 100,000 experts in more than 150 countries and over 130 years of innovation, we are the power behind our customers’ mission. Our leading portfolio of building technology and solutions includes some of the most trusted names in the industry, such as Tyco®, York®, Metasys®, Ruskin®, Titus®, Frick®, Penn®, Sabroe®, Simplex®, Ansul® and Grinnell®.
.jpeg)
