Senior Software Engineer - Database design and management.

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.