This job has expired, please see additional jobs below
Senior Database Administrator
Sony Pictures
Culver City, CA, United States
Job Details - this job has expired, please see similar jobs below
Sr Database Administrator, TV Digital Platform Group
The Digital Platform Group (DPG) at Sony Pictures Television is looking for a talented Senior Database Administrator to join the team. The DPG provides the platform and services for Sony Crackle and Sony Pictures Television Networks. This position is primary responsible for designing, developing, implementing, testing, and maintaining Azure SQL databases for the platform, which includes its content management system, search/recommendations and notifications engines, web sites, client apps and back-end services. The Senior DBA will report into the Executive Director, Platform Operations.
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.
About Sony Crackle
Sony Crackle is the place to escape and recharge, with exclusive Originals, blockbuster movies and hit TV shows for a console-first and connected streaming audience. Sony Pictures Television Networks' free, ad-supported network offers a handpicked, constantly updated programming line-up, like binge-worthy Sony Crackle Originals such as “The Oath,” “Snatch,” “StartUp” and “SuperMansion,” as well as movies and series in genres including Drama, Action, Fandom, Comedy and Thriller. The network is all on demand and accessible in the U.S. for free without subscription. Sony Crackle is available in 21 countries on a wide variety of connected devices. For more information, go to www.sonycrackle.com or follow @SonyCrackle on Facebook, Instagram and Twitter for real-time updates.
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 and maintain data extracts via SSDT and SSIS packages.
• Real time Data sync between Azure SQL and AWS DR SQL via Powershell and Azure Automation.
• Stored Procedure and Database Schema Review.
• Data Refreshing using 3rd party tool (such as Red-Gate Schema & Data Compare).
• Database Monitoring using 3rd party monitoring tools.
• Identify bad query executions and work with developers to optimize queries.
• Troubleshoot for any database schema sync issue.
• Monitor performance and managing parameters to provide fast responses to front-end users.
• Map 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.
REQUIREMENTS
• Minimum 5-7 years of professional MS server Administration experience.
• Minimum 2-3 years of professional Azure SQL or SQL Server Administration experience.
• Knowledge of variety of Databases including SQL Server or PostgresQL.
• Experience with SSDT and SSIS.
• Working experience of writing Stored Procedures.
• Working experience of leveraging executing plans.
• Working experience with Powershell and automating tasks via scripts and Azure Automation.
• Hands on experience with Data publish/subscribe services.
• Hands on experience with database load testing and Data Access Layers in C# or Java.
• Understanding of NOSQL Databases including MongoDB.
• Working knowledge of indexes, High Availability and Disaster Recovery (DR) options for Azure SQL or SQL Server.
• Must have strong database design skills. Must be able to explain database schema that he/she 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.
*Sony Pictures Entertainment is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status, age, sexual orientation, gender identity, or other protected characteristics.
• Sony Pictures - CA - Culver City Area & Studios