Associate Database Administrator
Facile Info-Serv Private Limited
About this job
Facile Serv is seeking a skilled and dedicated Database Administrator (SQL) to join our growing team in Kharadi, Pune. In this crucial role, you will be responsible for the management, maintenance, and optimization of our SQL databases, ensuring data integrity, security, and high availability. If you have a solid background in SQL and advanced Excel, and are passionate about data management and analysis, we encourage you to apply and contribute to our dynamic environment.
As a Database Administrator, you will play a key role in supporting our business operations by providing reliable data infrastructure and actionable insights. This position offers a fantastic opportunity for an experienced professional to enhance their skills in a challenging and rewarding setting, collaborating with development and business teams to meet diverse data requirements.
Key Responsibilities
- Manage, maintain, and ensure the optimal performance of various SQL databases.
- Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and views to improve data retrieval and processing efficiency.
- Perform regular database backup and recovery operations to safeguard critical business data.
- Proactively monitor database performance, identify bottlenecks, and implement solutions to resolve issues promptly.
- Ensure the highest standards of data integrity, security, and availability across all database systems.
- Generate comprehensive Management Information System (MIS) reports utilizing Advanced Excel functionalities.
- Proficiently use Excel functions such as VLOOKUP, XLOOKUP, Pivot Tables, IF statements, INDEX-MATCH, and various charting tools for robust reporting and data visualization.
- Import, clean, validate, and transform data from multiple sources to ensure accuracy and consistency.
- Collaborate effectively with development and business teams to understand data requirements and provide timely support.
- Maintain thorough documentation for all database processes, configurations, and reporting procedures.
Requirements
- 1 to 3 years of hands-on experience in Database Administration or SQL Database Support.
- Strong proficiency in SQL, including practical experience with SQL Server, MySQL, and PostgreSQL.
- Demonstrated understanding of database concepts, including data modeling, indexing strategies, join types, and query optimization techniques.
- Expertise in Advanced Excel, encompassing Pivot Tables, VLOOKUP/XLOOKUP, IF functions, data validation, and chart creation for reporting.
- Familiarity with database backup and recovery methodologies and tools.
- Excellent analytical, problem-solving, and critical thinking skills.
- Ability to work effectively both independently and as part of a collaborative team.
- Strong verbal and written communication skills to articulate technical concepts clearly.
What We Offer
- An opportunity to work as a Database Administrator in a dynamic and supportive work environment.
- Exposure to diverse database technologies and challenging projects.
- Continuous learning and professional development opportunities.
- A collaborative culture that values innovation and teamwork.
- Competitive compensation and a chance to make a significant impact.
Eligibility
Professionals • 1-3 years of experience