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.
– Troubleshoots and resolves applications (ex., SQL) performance issues.
– Forecasts utilization patterns and recommends modifications or upgrades.
– Proposes and implements enhancements to improve system performance and reliability.
– Conducts application transaction volume and traffic analysis and interprets the impact on database performance.
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.
– Monitors transactions between application systems and the database for the purpose of identifying and improving inefficiencies.
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.
– Has a broad level of understanding surrounding information systems,
application and/or Web standards and database licensing.
– 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 trends and compares them to expectations.
Conducts research to define problems and prepares responses to anticipated questions. Prioritizes multiple issues and opportunities. Identifies relationships and linkages within several information sources. Anticipates issues that are not readily apparent on the surface. Identifies root causes and effects. Defines priorities within performance objectives. Reports and identifies areas that need guidance to resolve complex issues. Anticipates the possible outcome of potential solutions.
Communication for Results
– Intermediate (I): Conducts discussions with and writes memoranda to all levels of colleagues and peer groups in ways that support troubleshooting and problem solving. Seeks and shares relevant information, opinions, and judgments. Handles conflict empathetically. Explains the context of inter-related situations, asks probing questions,
and solicits multiple sources of advice prior to acting.
Information Seeking
– Intermediate (I): Utilizes a variety of information and data sources pertaining to organizational and professional trends. Checks the source for omission and accuracy. Identifies the sources that are appropriate for specific types of information. Checks for bias and omission. Seeks out the appropriate people to approach for guidance either formally or informally depending on the type of issue. Links information in a lateral as well as linear manner. Finds hidden data. Relates and manipulates data from various sources to create a fuller picture. Investigates and uncovers root causes of a problem or issue.
Initiative
– Intermediate (I): Seeks out new challenges that require risk taking. Determines the resources, team support, and technical needs necessary to enable success and procures them. Keeps responding to the challenge in spite of obstacles and setbacks.
Problem Solving
– Intermediate (I): Applies simple problem-solving methodologies to diagnose and solve operational and interpersonal problems. Determines the potential causes of the problem and devises testing methodologies for validation. Shows empathy and objectivity toward individuals involved in the issue. Analyzes multiple alternatives, risks and benefits for a range of potential solutions. Recommends resource requirements and collaborates with impacted stakeholders.
Teamwork
– Advanced (A): Consistently fosters collaboration and respect among team members by addressing elements of the group process that impedes, or could impede, the group from reaching its goal. Engages the “right people”, despite location or functional specialty, in the team by matching individual capabilities and skills to the team’s goals. Works with a wide range of teams and readily shares lessons learned.
Thoroughness
– Advanced (A): Identifies potential areas of conflicting priorities and vulnerability in achieving standards. Reviews department’s progress against established goals, objectives, service level targets and project milestones. Supports others in achieving deliverables by efficiently allocating resources and providing common organizing systems, techniques, and disciplines. Maintains a proactive work review and approval process prior to assignment completion. Solicits internal and external customer evaluation of performance and devises measures for improvement.
Advantage Zensar
We are a technology consulting and services company with 11, 800+ associates in 33 global locations. More than 130 leading enterprises depend on our expertise to be more disruptive, agile and competitive. We focus on conceptualizing, designing, engineering, marketing, and managing digital products and experiences for high-growth companies looking to disrupt through innovation and velocity.
Zensar Technologies is an Equal Employment Opportunity (EEO) and Affirmative Action Employer, encouraging diversity in the workplace. Please be assured that we will consider all qualified applicants fairly, regardless of race, creed, color, ancestry, religion, sex, national origin, citizen status, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veterans’ status.
Zensar is a place where you are free to express yourself in an environment that values individuality, nurtures development and is mindful of wellbeing. We put our people and customers at the center of everything that we do. Our core values include:
Putting people first
Client-centricity
Collaboration
Grow. Own. Achieve. Learn. with Zensar: www.youtube.com/watch?v=i2NZsiQqVnU
Ready to #ExperienceZensar?
Begin your application by clicking on the ‘Apply Online’ button below. Be sure to have your resume handy!
If you’re having trouble applying, drop in a line to [email protected].
Primary Location : India-Maharashtra-Pune
Job Posting : Jun 28, 2023
Experience Required (In Years) : Minimum – 5 Maximum – 7
Hiring Insights
Job activity
–
▶️ DBA-Level 3
🖊️ Zensar Technologies
📍 Pune
Job Description Interested candidate can mail their resume at [email protected] Only experienced candidates freshers do not apply. Job Role: Flutter...
Apply For This Job– Nazwa jednostki organizacyjnej ZUS Oddział w Bielsku-Białej – Nazwa komórki organizacyjnej Wydział Orzecznictwa Lekarskiego i Prewencji – Miejsce pracy...
Apply For This JobJob Details Position – Company SecretaryQualification – Company Secretary degree holder with CS registration numberExperience 3 to 5 years’ experience...
Apply For This JobPosition: IT Director (Application Development, P&L analysis, Operations, presales experience) Industry: BFSI Location: Mumbai Experience : 20+ years Salary :...
Apply For This JobJob Name : Senior Manager Salary : 22000 – 25000 a Months Exp: 0 – 2 years Company Name :...
Apply For This JobPosition Type Full time Type Of Hire Experienced (relevant combo of work and education) Education Desired Bachelor of Information Technology...
Apply For This Job