Jobs
>
Thiruvananthapuram

    DBA with MS SQL + Postgre - Kerala, India - Netstager Technologies Pvt Ltd

    Netstager Technologies Pvt Ltd
    Netstager Technologies Pvt Ltd Kerala, India

    5 days ago

    Default job background
    Marketing / Advertising / Public Relations
    Description

    Key Responsibilities:

    • Database Development and Administration:
    • Design, implement, and maintain database structures according to best practices for performance and reliability.
    • Monitor database performance, implement changes and apply new patches and versions when required.
    • Ensure database security, integrity, stability, and system availability.
    • Administer database access permissions and privileges.
    • SQL Development:
    • Develop and optimize complex SQL queries, stored procedures, functions, and scripts for various business applications.
    • Troubleshoot and resolve database performance issues, optimizing SQL code for maximum efficiency and speed.
    • Collaborate with developers to integrate databases with existing systems and applications, providing SQL expertise.
    • Data Extraction and Analysis:
    • Extract, transform, and load (ETL) data from various sources for analytical reporting and insights.
    • Develop strategies for data acquisitions, archive recovery, and implementation of a database.
    • Work closely with data analysts and business stakeholders to understand data requirements and deliver comprehensive data reports and visualizations.
    • Maintenance and Support:
    • Provide 24/7 support for critical database issues and performance bottlenecks.
    • Plan and execute regular database backups and recovery procedures.
    • Document database architectures, procedures, and processes for reference and compliance purposes.

    Requirements:

    • Bachelor's degree in Computer Science, Information Technology, or related field.
    • 5+ years of proven experience in SQL development and database administration.
    • Strong knowledge of SQL Server, Oracle, or other relational database management systems.
    • Experience with data modeling, ETL processes, and business intelligence tools.
    • Proficiency in writing complex SQL queries and optimizing them for performance.
    • Familiarity with database security practices and disaster recovery techniques.
    • Excellent problem-solving skills and attention to detail.
    • Strong communication and collaboration abilities to work effectively across different teams.
    • Ability to manage multiple projects and meet tight deadlines.
    • Experience with cloud-based database services (e.g., Azure SQL Database, Managed Instances).

    Preferred Qualifications:

    • Knowledge of NoSQL databases and big data technologies.