Sr. DBA and BI Report Developer
This position is not available anymore, but there are more Other jobs
Sr. DBA and BI Report Developer

Walt Disney International

Posted

Closed

Sr. DBA and BI Report Developer

About the job

Overall Purpose of the Role:-

A database administrator (DBA) is responsible for the performance, integrity and security of databases across company. Role demands a service oriented mentality with a high sense of ownership. Additional role requirements are likely to include planning, development and troubleshooting.

As an integral member of our delivery team, the Business Intelligence (BI) Report Developer is
responsible for the design, development, implementation and support of mission-critical
Enterprise Business Intelligence (BI) reports. Working with cross-functional teams, you will participate to gather and document reporting requirements to meet business needs. Using your skills and experience as a BI Report Developer, you will then use those requirements to design, develop, test and implement reports and dashboards that utilize the underlying data store(s)/ data warehouse(s) / data mart(s).
Overall the responsibility will be 50% for DBA and 50% for BI Report development.
Responsibilities Areas of Responsibility :-
  • Maintenance and Administration of DB Server Instances into Prod-Stage-Dev environment
  • Working closely with IT project managers, database programmers and multimedia programmers.
  • Implementation and Maintenance of DB Server Clustering (Active/Passive).
  • Setup security, auditing and data encryption as per best practices and security best practices
  • Setup, Monitoring and troubleshooting of routine maintenance jobs (Backup/Restore, Indexing, Database Consistency Checks, batch jobs,).
  • Development of Automated Monitoring System to track schema level changes, using System Tables
  • Development and Implementation of Disaster Recovery plan, processes and procedures.
  • Administration and maintenance of SQL Server.
  • Analysis of DB Servers, Integration Services (SSIS), Batch processes, and architecture of related components
  • Created users, Logins, assigned roles and object level permissions for Security Maintenance
  • Upgrade, Migration, consolidation of Server instances and databases
  • Documentation, Troubleshooting for DBA team lead and support to users
  • Participate in team roster and providing shared telephone coverage
  • Apply changes to systems & procedures in accordance with Disney Standards
  • Publish incident and service information to the Disney IT Community
  • Participate in security and vulnerability auditing and reporting
  • Translate business requirements into specifications that will be used to implement the
  • required reports and dashboards, created from potentially multiple data sources
  • Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users
  • Ensure proper configuration management and change controls are implemented for your sphere of influence
  • Design and implement technology best practices, guidelines and repeatable processes
  • 4 to 8 years of experience developing and implementing enterprise-scale reports and dashboards which include:
  • Extensive experience with data warehouse implementations.
  • Knowledge of logical and physical data modeling concepts (relational and dimensional)
  • Proficiency with Microsoft power BI and data warehouse.
  • Performance tuning experience related to reporting queries required
    • Ability to manage multiple priorities, and assess and adjust quickly to changing priorities

    MANAGEMENT CONTROL
    • Manage, co-ordinate, and maintain relationships with 3rd party support staff in providing support to clients.
    • Responsible for maintaining asset records for hardware and software in the offices where support is provided.
    • Enforce corporate standards for hardware and software procurement and operation.
    • Enforce compliance with various local legislative requirements from an IT perspective including software licensing.

    Basic Qualifications Experience & Qualification:-

    Education

    Degree in Computer Science, Engineering, or equivalent qualification.

    Experience
    • Minimum of overall 4+ years work experience in managing DB’s
    • Good exposure towards scripting.
    • Excellent communications with technical understanding
    • Experience in service provision.

    Professional Qualification/Certification
    • DBA certification
    • Scripting
    Additional Information Skills Required:-
    • Methodical, disciplined approach
    • Strong collaborative skills
    • Cultural sensitivity
    • Excellent interpersonal and communication skills
    • Power BI
    Attributes (essential)
    • Team Players
    • Excellent planning, organizing, and leadership/supervisory skills
    • Strong collaborative skills
    • Methodical, disciplined approach
    • Business acumen
    • Aptitude for technology
    • Analytical skills
    • Committed to service excellence and continuous improvement
    • Excellent interpersonal skills
    • Highly developed and flexible communication skills
    • Embraces and seeks out change

    Language Skill

    • Good verbal and written communication skills in English
    Closed

    Sr. DBA and BI Report Developer

    Mumbai, India

    Full-time, Indefinite

    Start Date:

    Latest start date:

    Want something different? See similar jobs