EY Database Administrator- Senior in Bangalore, India
Database Administrator- Senior
Requisition # BEN0046L
Post Date Apr 06, 2018
The Database Administrator designs, manages, maintains and improves complex database systems and platforms throughout the entire database lifecycle. This role will view performance and efficiency as critical factors in the data services provided. Using their technical expertise, the Database Administrator will provide database solutions to the IT organization while maintaining a view on how these solutions will impact the enterprise. Judgements and recommendations will be made based on analysis and knowledge of the existing environment and available features provided by the database management systems.
Essential Duties and Responsibilities:
Ensures availability, security, integrity, and performance of assigned databases.
Recommends and implements data models and database designs that support efficient data access.
Exercises critical thinking and problem-solving when resolving database performance, capacity, replication, and other data issues.
Installs and configures database management software and applicable options, packs and patches while adhering to client’s standards.
Collaborates with developers and programmers to understand the potential architectural impacts of different database strategies and coding practices.
Develops and implements database deliverables, such as conceptual designs, logical designs, capacity planning, external data interface specifications, data loading plans, data maintenance plans, and security policies.
Builds IT solutions to ensure they meet the business needs while maintaining a focus on enterprise goals and integration strategies.
Partners with Business Teams to assess how technologies can best streamline processes and/or add business value.
Keeps current with key technology, business and industry trends.
Participates in disaster recovery and business continuity planning.
Develops innovative approaches to solving problems.
Follows both industry and client’s best practices and standards in all database areas.
Automates repetitive and/or error-prone tasks.
Schedules and manages jobs for data transfers and sundry procedures and monitors performance and impact on operations.
Analyzes long-term database performance trends to optimize database and application performance.
Configures, supports, and optimizes replication.
Performs other duties and responsibilities as assigned.
Experience and Skills:
Minimum of a B.S. in Computer Science, MIS or related degree and three (3) years of relevant experience including relational database theory and relational database programming experience or combination of education, training and experience.
Experience in Financial Services or other regulated industry preferred.
Experience with the following Oracle products and options
Oracle RDBMS Enterprise Edition
Real Application Clusters (RAC)
Replication solutions such as Data Guard and Golden Gate
Exadata and other engineered systems
Oracle Enterprise Manager (OEM)
Experience with PL/SQL code development and tuning
Performance tuning and analysis using AWR, ASH.
Scripting and automation using shell scripting, Perl, Python, etc.
Exposure to ITIL principles a plus.
Capacity planning for all aspects of a database system (storage, compute, memory, etc.)
Understanding of networking and connectivity and how it relates to a database environment.
Informed position on cloud services and options
- None required.
Competencies and Behaviours:
Analysis : Identify and understand issues, problems and opportunities; compare data from different sources to draw conclusions.
Communication : Clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.
Exercising Judgment and Decision Making : Use effective approaches for choosing a course of action or developing appropriate solutions; recommend or take action that is consistent with available facts, constraints and probable consequences.
Technical and Professional Knowledge : Demonstrate a satisfactory level of technical and professional skill or knowledge in position-related areas; remains current with developments and trends in areas of expertise.
Building Effective Relationships : Develop and use collaborative relationships to facilitate the accomplishment of work goals.
Client Focus : Make internal and external clients and their needs a primary focus of actions; develop and sustain productive client relationships.