Experience – 2.5 -6 years

Salary – 3.5 – 8 lac per anum

Industry – IT Software

Location – Chandigarh

Job Description for DBA position

The Database Administrator’s role is to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Responsibilities

Strategy & Planning

·         Assess and develop long-term strategic goals for production databases in conjunction with data owners and product managers.
·         Work with the DevOps team to develop database architectures, coding standards, quality assurance policies and procedures.
·         Design and implement redundant systems for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
·         Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Operational Management

·         Create models for new database development and/or changes to existing ones.
·         Install and configure relevant network components to ensure database access as well as database consistency and integrity.
·         Respond to and resolve database access and performance issues.
·         Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
·         Monitor, optimize and allocate data storage for database systems.
·         Plan and coordinate data migrations between systems.
·         Develop, implement, and maintain change control and testing processes for modifications to databases.
·         Create, or support creation of, required reports in response to business user needs.
·         Perform database transaction and security audits.
·         Establish appropriate end-user database access control levels.
·         Develop routines for end users to facilitate best practices in database use.
·         Manage and/or provide guidance to other members of the team.

Position Requirements:

Formal Education & Certification

·         College diploma or university degree in the field of Computer Science or Computer Engineering and/or 5 years equivalent of work experience.
·         MCSA (SQL Server) or MCSE (Data Platform/Business Intelligence).
Knowledge & Experience
·         Working experience in public and private cloud environments (AWS or Azure)
·         Strong understanding of relational database structures, theories, principles, and practices.
·         Working technical experience with designing, building, installing, configuring and supporting database servers, including Microsoft SQL Server 2012/2014 Enterprise, Azure SQL, DocumentDB and NoSQL Databases.
·         Knowledge of High Availability architecture such as Always-On Availability Groups.
·         Hands-on database tuning and troubleshooting experience.
·         Experience with data processing flowcharting techniques.
·         Project management experience.
·         Good understanding of the organization’s goals and objectives.
·         Knowledge of applicable data privacy practices and laws.
·         Sound understanding of PL/SQL Source Control (Git) models.

Personal Attributes

·         Good written and oral communication skills.
·         Strong technical documentation skills.
·         Good interpersonal skills.
·         Ability to conduct research into database issues, standards, and products as required.
·         Ability to present ideas in user-friendly language.
·         Highly self-motivated and directed.
·         Keen attention to detail.
·         Proven analytical and problem-solving abilities.
·         Strong customer service orientation.
·         Experience working in an Agile or DevOps team environment