Webologix Ltd/ INC | Database Administrator

Job Position: Database AdministratorJob Type: Contract to Hire (C2H)Company: Webologix Location: NoidaExperience: -5+ to 10+ YearsMust have: - PL/SQL, PostgreSQL, SQL, Azure DatabaseResponsibilities:Design and optimize PostgreSQL database solutions in collaboration with software developers, data analysts, and stakeholders.Translate data requirements into efficient database designs and implement data manipulation logic using SQL, PL/pgSQL, and PostgreSQL features.Write complex SQL queries, stored procedures, triggers, and functions to ensure data integrity and improve system performance.Play a crucial role in indexing strategies and query optimization to enhance overall system efficiency.Advise on best practices for database development and maintenance, including performance optimization, scalability, and data security.Create and maintain maintenance scripts for tasks such as backups, performance monitoring, and database optimization to ensure smooth operation of PostgreSQL database systems in production environments.Provide technical support and troubleshooting for database-related issues as needed.Document database designs, configurations, and maintenance procedures for reference and knowledge sharing within the team.Knowledge transfer to development teamsBachelor's degree or equivalentTechnical SkillsProficiency in SQL (Structured Query Language) for data manipulation and querying.Strong understanding of PL/SQL for developing stored procedures, triggers, and functions in PostgreSQL.In-depth knowledge of PostgreSQL features and functionalities, including advanced features such as partitioning, replication, and JSONB data types.Experience with OLAP database schema designAbility to optimize SQL queries and database performance using techniques such as indexing, query tuning, and analyzing execution plans.Familiarity with database security principles and best practices, including access controls, encryption, and authentication mechanisms.Experience in creating and maintaining maintenance scripts for tasks such as backups, monitoring, and performance optimization.Understanding of database high availability and disaster recovery solutions, such as replication, clustering, and failover mechanisms.Proficiency in version control systems like Git for managing database schema changes and configurations.Understanding of data warehousing concepts and techniques for managing large volumes of data effectively.Experience with database administration tasks such as database installation, configuration, and upgrades is a plus.Strong problem-solving skills and ability to troubleshoot database-related issues effectively.Familiarity with cloud-based database solutions like Amazon RDS, Google Cloud SQL, or Azure Database for PostgreSQL is advantageous.CompetenciesAnalytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; designs workflows and procedures.Design - Generates creative solutions; translates concepts and information into images; Uses feedback to modify designs; applies design principles; demonstrates attention to detail.Problem Solving - Identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem solving situations.Technical Skills -Assesses own strengths and weaknesses; Pursues training and development opportunities; strives to continuously build knowledge and skills; Shares expertise with others.Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Able to read and interpret written information.Corporate Competencies • Diversity - Shows respect and sensitivity for cultural differences; promotes a harassment-free environment.Quality Management -Looks for ways to improve and promote quality; demonstrates accuracy and thoroughness.Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration; Follows through on commitments.Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Able to deal with frequent change, delays, or unexpected events AGG