Senior Database Administrator

Sony Pictures Entertainment

(Culver City, California)
Full Time
Job Posting Details
About Sony Pictures Entertainment
Sony Pictures Entertainment (SPE) is a subsidiary of Sony Entertainment Inc., a subsidiary of Tokyo-based Sony Corporation. Our unlimited passion for technology, content and services, and relentless pursuit of innovation, drives us to deliver ground-breaking new excitement and entertainment in ways that only Sony can.
Summary
Crackle is looking for a DBA to join the Engineering team in Culver City, CA. This position’s primary responsibility includes designing, developing, implementing, testing, and maintaining Azure SQL databases for the Crackle.com platform, which includes its content management system, search/recommendations and notifications engines, web sites, client apps and back-end services. In addition, this role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues in timely manner.
Responsibilities
* Azure Database backup and restore from Azure/Aws table Storage * Manage Azure Geo-Replica databases * Perform database index/statistic tuning daily * Implement data partitioning or sharding based on the data scale. * Create reports for business users * Real time Data sync between Azure SQL and AWS DR SQL * Stored Procedure and Database Schema Review * Data Refreshing using 3rd party tool (such as Redgate Schema Compare and Data Compare, Microsoft SSDT schema and data comparer) * Database Monitoring using NewRelic or other monitoring tools * Identify bad query executions * Troubleshoot for any database schema sync issue * Monitor performance and managing parameters to provide fast responses to front-end users * Mapp out the conceptual design for a planned database * Refine the logical design so that it can be translated into a specific data model * Further refine the physical design to meet system storage requirements * Maintain data standards, including adherence to the Data Protection Act * Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata) * Control database access permissions and privileges * Develop, manage and test back-up and recovery plans * Ensure that storage and archiving procedures are functioning correctly * Capacity planning * Work closely with IT project managers, solutions architects and software developers * Communicate regularly with technical, applications and operational staff to ensure database integrity and security
Ideal Candidate
* Minimum 5-7 years of professional MS server Administration experience * Minimum 2-3 years of professional Azure SQL Administration experience * Knowledge of database managements * Experience with SSDT * Working experience of writing Stored Procedures * Working experience of leveraging executing plans * Hands on experience with Data publish/subscribe services * Hands on experience with database load testing and Data Access Layers in C# or Java * Working experience with other NoSQL and table storages. * Working knowledge of indexes, High Availability and Disaster Recovery(DR) options for Azure SQL * Must have strong database design skills. Must be able to explain database schema that they have designed, including tradeoffs they made and why. * Excellent written and verbal communications skills – good at documenting code * Detail-oriented, well organized, quick learner with very strong technical aptitude and the ability to work concurrently on multiple projects

Questions

Answered by on
This question has not been answered
Answered by on

There are no answered questions, sign up or login to ask a question

Want to see jobs that are matched to you?

DreamHire recommends you jobs that fit your
skills, experiences, career goals, and more.