We look for the risk-takers, the collaborators, the inspired and the inspirational. We want the people who are brave enough to work at the cutting edge and create solutions that will enrich and improve the lives of people across the globe. So, if you want to make the world say wow, let's talk.
The conversation starts here. If this role matches your ambitions and skillset, let's get started with your application. Take a look at our other open positions too. Our many opportunities can lead to infinite possibilities.
Title:
Cloud Database Architect
About the role:
- This is a HANDS-ON engineering position for individuals with a passion for analyzing, designing, developing, and operationalizing database and analytics solutions using AWS database and data technologies.
- The role is 70% focused on new projects & enhancements and 30% focused on providing operations support.
- This is a Full-time Employee (Permanent Staff) position based out of the Sony Office in Bengaluru.
- Work-from-home option is available based on the situation.
Education:
- A university bachelor's degree in Computer Science or Business Intelligence or Data Analytics is a must-have.
- Solid knowledge of data modeling and database design
- Solid knowledge of workings of a distributed database models including SQL, No-SQL and performance optimization
- Solid knowledge of data structures and algorithms
- Solid knowledge of AWS database and data technologies
Recruiting Team:
The recruiting team works on various security domains like Endpoint Security, Inventory Mgmt., IAM, Threats & Vulnerabilities Mgmt., Reporting & Data Science.
Prior Experience:
- Must-Haves:
- MUST-HAVE: Overall technology experience of 8+ years
- MUST-HAVE: Minimum experience of 5 years in data modelling and database design
- MUST-HAVE: Minimum experience of 7 years in designing, implementing, and supporting medium to large scale database systems
- MUST-HAVE: Minimum experience of 5 years in designing, developing, and supporting solutions using S3, Redshift, DynamoDB and any of the Managed RDS
- MUST-HAVE: Minimum experience of 4 years designing, developing, and tuning solutions using AWS database and storage technologies
- Preferred:
- Prior experience with designing, developing, and supporting solutions using database technologies like MySQL, PostgreSQL, Cassandra is a plus
- Experience with designing, developing, and supporting solutions using Map Reduce, Kafka, & Streaming technologies is a plus
- Advanced python programming skills is a plus
Day-to-day responsibilities:
- Understand the business domain, core data objects, data entities. Model the relationships between the various entities
- Design the data warehouse, data mart and transactional databases including all facets of load parameters
- Induct aspects of high performance, security, usability, operability, maintainability, traceability, observability, evolvability into the systems design
- Assess performance influencing parameters like normalization, de-normalization, most executed transactions, record count, data size, I/O parameters at the database and OS level in the database and table designs
- Maintain a catalog of meta, master, transactional and reference data
- Tune the transactions and queries and determine the use of appropriate client libraries and fetch mechanism (like query vs stored procedures)
- Design the system for resilience, fail-over, self-healing and institute rollback plans
- Develop and test database code and other core and helper utilities in Python
- Develop and profile queries, triggers, indices, and stored procedures
- Monitor the health of queries and identify patterns leading to bottlenecks in the system before the customer finds it
- Own the DevOps and release mgmt. practices pertaining to the database solutions
- Estimate the cost of AWS services usage and look to continuously optimize the cost
- Design and develop data REST API layer on Python
Success Factors:
- Critical thinking, analytical & logical mind with a problem-solving aptitude
- Strong desire to learn, experiment and iterate new solutions
- Possess excellent fluency in English and excellent oral and written communication skills
- Be able to clearly explain the design and the design decisions rooted in logic and core requirements
- Be able to function in an environment where the team is virtual and geographically dispersed
Top Skills
What We Do
See everything new from the world of Sony USA—including electronics, PlayStation, movies, music and TV shows—plus find support for your Sony products.
Sony’s purpose is simple. We aim to fill the world with emotion, through the power of creativity and technology. We want to be responsible for getting hearts racing, stirring ambition, and putting a smile on the faces of our customers. That challenge, combined with our spirit of innovation, motivates us to create groundbreaking technology, entertainment, and services for people worldwide.
Our history as a global brand has been built around employees that all have a passion for touching peoples' lives, and pride in pushing beyond the status quo to produce truly extraordinary results.
We’re uniquely positioned because we operate in many different industries - from movies and music to video games and electronics. And, with offices around the globe, we benefit from a global workforce that learns and grows together through mutual respect.
If you're ready to join a diverse team at an innovation-led company with the power to change lives, then we encourage you to read up on the different Sony group companies and check out our Life page. Then, get in touch, and together, let’s make the world say wow.
