Job Description
Primary Job Duties:
Coordinate planning, administration, monitoring, tuning and performance optimization of SQL Server/Postgresql production databases, including optimization of stored procedures, triggers, tables, indices, and configuration settings.
Perform database creation, definition of physical and logical structures, documentation, definition of operational guidelines, and data protection.
Formulate and monitor database management policies, procedures, and standards, and propose as well as implement improvements to performance and reliability of database systems.
Work to identify and resolve poorly performing queries that require tuning and/or optimization, as well as, monitor open support tickets, determine trends, and identify areas for improvement.
- 5-7 years of relevant experience, as well as a Bachelors degree.
- 4-6 Postgresql Database experience, and be able to demonstrate that experience.
- 2-3 SQL Server Database experience, and be able to demonstrate that experience.
- experience to work in Cloud environments. AWS preferably.
- knowledge on ETL/ELT processes.
- performance tuning skills
- Design & Modelling skills for OLTP & OLAP. Exposure to data modelling tools. ERWin preferably
- Knowledge on NoSQL databases (atleast experience in one like MongoDB/Cassandra )
Good to Have - ability to plan, implement, maintain, and troubleshoot high-availability techniques such as hot standby servers, clustering, database mirroring, and AlwaysOn.
- experience on SSIS/SSRS
- experience with Python
- understanding/knowledge of Scripting languages like Shell, Pearl, etc.
- exposure to database deployment automation (CI/CD & version control)
Job Classification
Industry: Real Estate, Property
Functional Area: IT Software - DBA, Datawarehousing,
Role Category: Programming & Design
Role: Programming & Design
Employement Type: Full time
Education
Under Graduation: Any Graduate in Any Specialization
Post Graduation: Post Graduation Not Required
Doctorate: Doctorate Not Required
Contact Details:
Company: CBRE Group
Location(s): Hyderabad
Keyskills:
Performance tuning
Automation
Postgresql
SSRS
OLAP
Stored procedures
SSIS
Monitoring
SQL
Python