Dba-level 3

**DBA-Level 3**
**-**
**(**
**0101338**
**)**

**Description**
- Database Administrator
- Cloud and Hosting (Location - Pune)
- Looking for a workplace where people realize their full potential, are recognized for the impact they make, and enjoy the company of the peers they work with? Welcome to Zensar Read on for more details on the role and about us.

What's this role about?
- As a Database Administrator, you will be responsible for planning and organizing database activities regarding reliability, performance monitoring and tuning, security, backup, and disaster recovery.
- Here's how you'll contribute:

- In this role you will help us:

- Participate in long term planning for software and hardware upgrades.
- Works with Project Managers to allocate DBA resources.
- Design/Develop
- Works with analysts to understand business needs.
- Participates in cross-team and cross-project implementations.
- Translates logical data models into physical database designs.
- Develops physical databases.
- Assists system engineer in the design of highly available and redundant storage area networks.
- Establishes information flows.
- Develops and maintains enterprise data documentation and metadata models.
- Develops and provides database requirements to system administrators.
- Designs, monitors, and maintains data replication primary and secondary databases.
- Develops, tests, maintains, and exercises procedures for backup, restoration and disaster recovery for high availability, high volume mission critical databases.
- Designs, codes, edits, installs, and verifies stored procedures and functions for accessing, maintaining, and populating databases.
- Recommends and implements DB solutions to support data integrity efforts.
- Designs and implements required security controls are designed around data and databases.
- Testing
- Participates in projects that require testing and produces metrics and samples for further analysis.
- Performance Management
- Ensures optimal database performance and availability.
- Monitors utilization for capacity planning.
- Forecasts utilization patterns and recommends modifications or upgrades.
- Proposes and implements enhancements to improve system performance and reliability.
- Database Administration
- Maintains development, production, and multiple testing environments.
- Oversees the upgrades of databases, adding new structures or elements.
- Provides, evaluates, and develops data access tools and techniques.
- Directs the scheduling of DBMS software installations.
- Builds scripts automating the daily operations of database management.
- Database Security
- Maintains and monitors database security, integrity, and access controls.
- Controls privileges and permissions to database users.
- Provides audit trails to detect potential security violations.
- Makes recommendations to improve security.
- Participates in security investigations as needed.
- Assures that appropriate information security is applied in all tasks.
- Database Support
- Provides production support/ database access 24 hrs. x 7 days a week and ensures high availability.
- Conducts Level 2 and 3 support.
- Troubleshoots databases accessibility, availability, or operability problems.
- Determines the appropriate course of actions for problems, identifies and mitigates risks, and implements solutions.
- Escalates/communicates issues when necessary.
- Policies, Processes, and Standards
- Assists in establishing and supporting enterprise policies, processes, and standards.
- Ensures standards are adhered to.
- Service Level Agreements
- Monitors performance against service agreement levels.
- Participates in developing SLAs.
- Ensures that operating level agreements are met with internal/external customers.
- Coaching/Mentoring
- Coaches and mentors team members.
- Provides performance feedback to managers.
- Research/Evaluation
- Evaluates future technologies and makes recommendations for software and hardware upgrades and technology solutions.

**Skills required to contribute**:

- We’re looking for someone with:

- Bachelor’s degree in programming/systems or computer science, information systems, specialized training, certification, or equivalent work experience.
- Typically requires 5 or more years of database administration experience working with various database management systems.
- Thorough understanding of performance monitoring, analysis, and tuning
- Adaptability
- Advanced (A): Calmly takes control of high-pressure situations. Maximizes the output of limited resources. Shifts tactics and redefines organizational priorities. Implement new practices when original approach and assumptions are no longer valid. Conducts transition planning and fosters employee involvement. Manages high-level milestone accomplishments across multiple change activities. Recommends large-scale change interventions.
- Analytical Thinking
- Intermediate (I): Coordinates the information gathering and reporting process. Reviews t