Apply Now

Principal Engineer

Culver City, CA, USA | Sony Pictures Entertainment Inc.

  • Industry:
    Media / Entertainment
  • Position Type:
    Full-Time
  • Functions:
    Engineering
  • Experience:
Job Description:
48 people have viewed this job

The Principal Engineer, Database is part of the Database Services Group within Enterprise Infrastructure Services (EIS) at Sony Pictures Entertainment (SPE).The Principal Engineer functions as a Senior Level Engineer working in a large and complex multiple RDMS environment.He/She is a contributor to the overall day-to-day database operations and will be part of a team that shares responsibility for technical support activities.Operating as a member of this team, the Principal Engineer should be capable of independent thinking but still have a willingness to follow predefined EIS policies in order to satisfy our customers.The scope of data management operations includes the activities such as database administration, enterprise application integration, and data warehousing support on-prem & Cloud.More specific tasks which the candidate will be responsible for are scripting, design & analysis, installation, configuration, monitoring, support, troubleshooting and tuning of both Cloud and on-prem databases.The primary database platform at SPE is Oracle & SQL Server running on Linux and Windows platforms respectively.Other environment includes EDB, MySQL, MongoDB and MarkLogic running on Linux and Windows servers. 


1. Database Operational Support - Proactively monitor and resolve incidents/problems that may impact the data management operations. Some key activities include: 


Respond, prioritize, and escalate incidents or service requests as necessary according to EIS processes and procedures. 

Coordinate significant change management initiatives both internally and with external IT teams. 

Participate in problem management task forces and perform root-cause troubleshooting. 

Maintain enough documentation with key system configurations and operational procedures to meet all support needs and situations. 

Develop and implement database operational procedures 

Develop processes to monitor databases and event logs

Develop automation deployment pipeline

Perform maintenance of database system software 

Perform migration of all database modifications to the QA and production environments  

Implement monitoring solutions as defined by Senior Staff Members 

Implement backup solutions as defined by Senior Staff Members 

Assist with the loading of production data and any other issues regarding data loads. 

Assist with system configurations, database upgrades and migrations. 

Verify nightly backups and transaction log dumps 

Monitor databases and event logs 

Manage database accounts and logins 

Assist in developing and implement database operational procedures. 


2. Database Engineering & Design – Assess, plan, and build capability to provide data management related services to all levels of the IT organization. Some key activities includes: 


Ensure adequate capacity is available at all times to meet the requirements of the operations and business through capacity planning and management. 

Design, implement, measure and manage database services to ensure the stated business requirements for availability are consistently met. 

Continue to provide a pre-determined and agreed level of database services to support the minimum business requirements following an interruption to the database operations. 

Assist with installations and configurations of new database environments 

Assist with capacity and resource planning 

Assist with database performance analysis and server tuning activities 

Assist with the development and implementation of standards, policies and procedures. 

Support application development functions. 

Maintain service level agreements, policies and procedures 

Assist with application support functions, including coordinating vendor assisted support 


3. Security Management – Ensure the confidentiality, Integrity and availability of data. Some key activities includes: 


Ensure data integrity through sound backup and recovery procedures. 

Define and implement access controls to the data to meet audit and security requirements. 

Work with information security and internal/external auditors to coordinate audit and compliance activities. 

Create and maintain security and application roles for all databases. 

Restore data, upon request, to the Development, QA or Production environments 



Requirements:


BS or BA degree in computer science, information technology, business administration or related technology field. 


Other companies hiring with Ivy Exec

 Company Logos