Database Administrator (SQL + NO SQL)
Posted 2 days ago
Job Viewed
Job Description
Job Scope:
- Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.
- Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc.
- Providing DB design solutions, hands-on expert using SQL and other DB related tools.
- Providing solutions for Database High Availability (HA), Data Security, Governance, compliance measures etc.
You’ll be Responsible for?
- Ensure optimal health, integrity, availability, performance, and security of all databases.
- Develop and maintain data categorization and security standards.
- Evaluate and recommend new database technologies and management tools; optimize existing and future technology investments to maximize returns.
- Provide day-to-day support to internal IT support groups, external partners, and customers as required.
- Manage outsourced database administration services to perform basic monitoring and administrative-level tasks as directed.
- Participate in change and problem management activities, root cause analysis, and development of knowledge articles to support the organization’s program.
- Support application testing and production operations. Serve as database administration.
- Document, monitor, test, and adjust backup and recovery procedures to ensure important data is available in a disaster scenario.
- Serve as On-Call database administrator on a rotating basis.
- Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo, ClickHouse, Cassandra, Scylla DB and Oracle Instances including automated scripts for monitoring and maintenance of individual databases.
- Diligently teaming with the infrastructure, network, database, application, and business intelligence teams to guarantee high data quality and availability.
- Collaborating with various teams to install Database software updates, patches, version upgrades when required.
- Performance tuning of Databases, SQL Query tuning, optimizing database designs.
- Knowledge of schedulers - Cron, or any other new generation schedulers like Apache Airflow
- Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations.
- Responsible for implementation and ongoing administration of Data Pipelines
What you’d have?
- B.E./B.Tech/MCA from a premier institute
- 5-9 years of experience in managing enterprise databases
Knowledge and Skills
- Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, ClickHouse DB & NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.
- Installing MySQL, PostgreSQL, ClickHouse DB , Oracle , Cassandra, Scylla DB & Mongo DB.
- Backup and Recovering Oracle, MySQL, Mongo DB, ClickHouse DB Cassandra, Scylla DB and PostgreSQL databases.
- User level Access: Risks & Threats.
- Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
- Linux operating systems (RHEL, Ubuntu, CentOS), including shell scripting.
- Windows Server operating system
- Industry-leading database monitoring tools and platforms
- Data integration techniques, platforms, and tools
- Modern database backup technologies and strategies
Why join us?
- Impactful Work : Play a pivotal role in safeguarding Tanla's assets, data, and reputation in the industry.
- Tremendous Growth Opportunities : Be part of a rapidly growing company in the telecom and CPaaS space, with opportunities for professional development.
- Innovative Environment: Work alongside a world-class team in a challenging and fun environment, where innovation is celebrated.
Tanla is an equal opportunity employer. We champion diversity and are committed to creating an inclusive environment for all employees.
Database Administrator (SQL + NO SQL)
Posted today
Job Viewed
Job Description
Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.
Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc.
Providing DB design solutions, hands-on expert using SQL and other DB related tools.
Providing solutions for Database High Availability (HA), Data Security, Governance, compliance measures etc.
You’ll be Responsible for?
Ensure optimal health, integrity, availability, performance, and security of all databases.
Develop and maintain data categorization and security standards.
Evaluate and recommend new database technologies and management tools; optimize existing and future technology investments to maximize returns.
Provide day-to-day support to internal IT support groups, external partners, and customers as required.
Manage outsourced database administration services to perform basic monitoring and administrative-level tasks as directed.
Participate in change and problem management activities, root cause analysis, and development of knowledge articles to support the organization’s program.
Support application testing and production operations. Serve as database administration.
Document, monitor, test, and adjust backup and recovery procedures to ensure important data is available in a disaster scenario.
Serve as On-Call database administrator on a rotating basis.
Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo, ClickHouse, Cassandra, Scylla DB and Oracle Instances including automated scripts for monitoring and maintenance of individual databases.
Diligently teaming with the infrastructure, network, database, application, and business intelligence teams to guarantee high data quality and availability.
Collaborating with various teams to install Database software updates, patches, version upgrades when required.
Performance tuning of Databases, SQL Query tuning, optimizing database designs.
Knowledge of schedulers - Cron, or any other new generation schedulers like Apache Airflow
Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations.
Responsible for implementation and ongoing administration of Data Pipelines
What you’d have?
B.E./B.Tech/MCA from a premier institute
5-9 years of experience in managing enterprise databases
Knowledge and Skills
Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, ClickHouse DB & NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.
Installing MySQL, PostgreSQL, ClickHouse DB , Oracle , Cassandra, Scylla DB & Mongo DB.
Backup and Recovering Oracle, MySQL, Mongo DB, ClickHouse DB Cassandra, Scylla DB and PostgreSQL databases.
User level Access: Risks & Threats.
Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
Linux operating systems (RHEL, Ubuntu, CentOS), including shell scripting.
Windows Server operating system
Industry-leading database monitoring tools and platforms
Data integration techniques, platforms, and tools
Modern database backup technologies and strategies
Why join us?
Impactful Work : Play a pivotal role in safeguarding Tanla's assets, data, and reputation in the industry.
Tremendous Growth Opportunities : Be part of a rapidly growing company in the telecom and CPaaS space, with opportunities for professional development.
Innovative Environment: Work alongside a world-class team in a challenging and fun environment, where innovation is celebrated.
Tanla is an equal opportunity employer. We champion diversity and are committed to creating an inclusive environment for all employees.
Database Administrator (SQL + NO SQL)
Posted today
Job Viewed
Job Description
Job Scope:
- Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.
- Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc.
- Providing DB design solutions, hands-on expert using SQL and other DB related tools.
- Providing solutions for Database High Availability (HA), Data Security, Governance, compliance measures etc.
You’ll be Responsible for?
- Ensure optimal health, integrity, availability, performance, and security of all databases.
- Develop and maintain data categorization and security standards.
- Evaluate and recommend new database technologies and management tools; optimize existing and future technology investments to maximize returns.
- Provide day-to-day support to internal IT support groups, external partners, and customers as required.
- Manage outsourced database administration services to perform basic monitoring and administrative-level tasks as directed.
- Participate in change and problem management activities, root cause analysis, and development of knowledge articles to support the organization’s program.
- Support application testing and production operations. Serve as database administration.
- Document, monitor, test, and adjust backup and recovery procedures to ensure important data is available in a disaster scenario.
- Serve as On-Call database administrator on a rotating basis.
- Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo, ClickHouse, Cassandra, Scylla DB and Oracle Instances including automated scripts for monitoring and maintenance of individual databases.
- Diligently teaming with the infrastructure, network, database, application, and business intelligence teams to guarantee high data quality and availability.
- Collaborating with various teams to install Database software updates, patches, version upgrades when required.
- Performance tuning of Databases, SQL Query tuning, optimizing database designs.
- Knowledge of schedulers - Cron, or any other new generation schedulers like Apache Airflow
- Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations.
- Responsible for implementation and ongoing administration of Data Pipelines
What you’d have?
- B.E./B.Tech/MCA from a premier institute
- 5-9 years of experience in managing enterprise databases
Knowledge and Skills
- Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, ClickHouse DB & NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.
- Installing MySQL, PostgreSQL, ClickHouse DB , Oracle , Cassandra, Scylla DB & Mongo DB.
- Backup and Recovering Oracle, MySQL, Mongo DB, ClickHouse DB Cassandra, Scylla DB and PostgreSQL databases.
- User level Access: Risks & Threats.
- Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
- Linux operating systems (RHEL, Ubuntu, CentOS), including shell scripting.
- Windows Server operating system
- Industry-leading database monitoring tools and platforms
- Data integration techniques, platforms, and tools
- Modern database backup technologies and strategies
Why join us?
- Impactful Work : Play a pivotal role in safeguarding Tanla's assets, data, and reputation in the industry.
- Tremendous Growth Opportunities : Be part of a rapidly growing company in the telecom and CPaaS space, with opportunities for professional development.
- Innovative Environment: Work alongside a world-class team in a challenging and fun environment, where innovation is celebrated.
Tanla is an equal opportunity employer. We champion diversity and are committed to creating an inclusive environment for all employees.
Database Administrator (SQL + NO SQL)
Posted 13 days ago
Job Viewed
Job Description
Job Scope:
- Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.
- Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc.
- Providing DB design solutions, hands-on expert using SQL and other DB related tools.
- Providing solutions for Database High Availability (HA), Data Security, Governance, compliance measures etc.
You’ll be Responsible for?
- Ensure optimal health, integrity, availability, performance, and security of all databases.
- Develop and maintain data categorization and security standards.
- Evaluate and recommend new database technologies and management tools; optimize existing and future technology investments to maximize returns.
- Provide day-to-day support to internal IT support groups, external partners, and customers as required.
- Manage outsourced database administration services to perform basic monitoring and administrative-level tasks as directed.
- Participate in change and problem management activities, root cause analysis, and development of knowledge articles to support the organization’s program.
- Support application testing and production operations. Serve as database administration.
- Document, monitor, test, and adjust backup and recovery procedures to ensure important data is available in a disaster scenario.
- Serve as On-Call database administrator on a rotating basis.
- Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo, ClickHouse, Cassandra, Scylla DB and Oracle Instances including automated scripts for monitoring and maintenance of individual databases.
- Diligently teaming with the infrastructure, network, database, application, and business intelligence teams to guarantee high data quality and availability.
- Collaborating with various teams to install Database software updates, patches, version upgrades when required.
- Performance tuning of Databases, SQL Query tuning, optimizing database designs.
- Knowledge of schedulers - Cron, or any other new generation schedulers like Apache Airflow
- Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations.
- Responsible for implementation and ongoing administration of Data Pipelines
What you’d have?
- B.E./B.Tech/MCA from a premier institute
- 5-9 years of experience in managing enterprise databases
Knowledge and Skills
- Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, ClickHouse DB & NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.
- Installing MySQL, PostgreSQL, ClickHouse DB , Oracle , Cassandra, Scylla DB & Mongo DB.
- Backup and Recovering Oracle, MySQL, Mongo DB, ClickHouse DB Cassandra, Scylla DB and PostgreSQL databases.
- User level Access: Risks & Threats.
- Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
- Linux operating systems (RHEL, Ubuntu, CentOS), including shell scripting.
- Windows Server operating system
- Industry-leading database monitoring tools and platforms
- Data integration techniques, platforms, and tools
- Modern database backup technologies and strategies
Why join us?
- Impactful Work : Play a pivotal role in safeguarding Tanla's assets, data, and reputation in the industry.
- Tremendous Growth Opportunities : Be part of a rapidly growing company in the telecom and CPaaS space, with opportunities for professional development.
- Innovative Environment: Work alongside a world-class team in a challenging and fun environment, where innovation is celebrated.
Tanla is an equal opportunity employer. We champion diversity and are committed to creating an inclusive environment for all employees.
Database Administrator (SQL + NO SQL)
Posted today
Job Viewed
Job Description
Job Scope:
- Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.
- Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc.
- Providing DB design solutions, hands-on expert using SQL and other DB related tools.
- Providing solutions for Database High Availability (HA), Data Security, Governance, compliance measures etc.
You’ll be Responsible for?
- Ensure optimal health, integrity, availability, performance, and security of all databases.
- Develop and maintain data categorization and security standards.
- Evaluate and recommend new database technologies and management tools; optimize existing and future technology investments to maximize returns.
- Provide day-to-day support to internal IT support groups, external partners, and customers as required.
- Manage outsourced database administration services to perform basic monitoring and administrative-level tasks as directed.
- Participate in change and problem management activities, root cause analysis, and development of knowledge articles to support the organization’s program.
- Support application testing and production operations. Serve as database administration.
- Document, monitor, test, and adjust backup and recovery procedures to ensure important data is available in a disaster scenario.
- Serve as On-Call database administrator on a rotating basis.
- Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo, ClickHouse, Cassandra, Scylla DB and Oracle Instances including automated scripts for monitoring and maintenance of individual databases.
- Diligently teaming with the infrastructure, network, database, application, and business intelligence teams to guarantee high data quality and availability.
- Collaborating with various teams to install Database software updates, patches, version upgrades when required.
- Performance tuning of Databases, SQL Query tuning, optimizing database designs.
- Knowledge of schedulers - Cron, or any other new generation schedulers like Apache Airflow
- Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations.
- Responsible for implementation and ongoing administration of Data Pipelines
What you’d have?
- B.E./B.Tech/MCA from a premier institute
- 5-9 years of experience in managing enterprise databases
Knowledge and Skills
- Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, ClickHouse DB & NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.
- Installing MySQL, PostgreSQL, ClickHouse DB , Oracle , Cassandra, Scylla DB & Mongo DB.
- Backup and Recovering Oracle, MySQL, Mongo DB, ClickHouse DB Cassandra, Scylla DB and PostgreSQL databases.
- User level Access: Risks & Threats.
- Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
- Linux operating systems (RHEL, Ubuntu, CentOS), including shell scripting.
- Windows Server operating system
- Industry-leading database monitoring tools and platforms
- Data integration techniques, platforms, and tools
- Modern database backup technologies and strategies
Why join us?
- Impactful Work : Play a pivotal role in safeguarding Tanla's assets, data, and reputation in the industry.
- Tremendous Growth Opportunities : Be part of a rapidly growing company in the telecom and CPaaS space, with opportunities for professional development.
- Innovative Environment: Work alongside a world-class team in a challenging and fun environment, where innovation is celebrated.
Tanla is an equal opportunity employer. We champion diversity and are committed to creating an inclusive environment for all employees.
SQL Database Administrator
Posted today
Job Viewed
Job Description
Job Summary:
We’re seeking a Database Administrator to manage and support SQL Server databases on mission-critical high-volume OLTP production systems. The ideal candidate will possess some database development background as well as current experience as a production SQL Server database administrator. The role requires a proactive and self-motivated individual, who is willing to take an idea, groom it into a well-defined user story, and see through the implementation.
Know your team:
We provide Cloud Managed Services on Azure and AWS. We also offer Managed Virtual Desktops, Managed Office and Managed DevOps. Currently, we have 25+ customers across US and India region. As a managed cloud service provider, BizDynamics offers customized solutions that offer scalability and seamless deployment capabilities through an integrated approach that includes Rapid cloud deployments configured and tailored to customer business needs, Enhanced compliance and security features, Scalability and agility with pay-as-you-go models, High productivity through effective resource utilization, Continuous guidance from planning strategies to executing them, Business continuity with ease in dealing with heavy workloads. MCP currently it is CIMS (Cloud Infra Managed Services)
Responsibilities:
Requirements:
Candidates are required to have these mandatory skills to assess the eligibility of the profile. The must have requirements are:
Implementing and administration of backup/restoration, disaster recovery and space monitoring plans by making space usage forecasts.
About the Company:
ValueMomentum is amongst the fastest growing insurance-focused IT services providers in North America. Leading insurers trust ValueMomentum with their core, digital and data transformation initiatives. With a consistent compound annual growth rate (CAGR) of 24%, we have now grown to over 4000 employees. ValueMomentum is committed to integrity and to ensuring that each team and employee is successful. We foster an open work culture where employees’ opinions are valued. We believe in teamwork and cultivate a sense of fun, fellowship, and pride among our employees.
Benefits:
We at ValueMomentum offer you the opportunity to grow by working alongside the experts. Some of the benefits you can avail are:
Information:
Interested candidates who fulfill requirements can apply for the role with their updated CVs here. Candidates are requested to be aware of the under our name.
SQL Developer
Posted 2 days ago
Job Viewed
Job Description
Position Overview:
We are seeking a highly skilled SQL Developer with deep expertise in SQL query performance tuning and database optimization. This role demands a strong command of SQL and focuses on improving the efficiency and speed of queries, stored procedures, and overall database performance. The ideal candidate will be responsible for ensuring fast, reliable access to both real-time and historical data through rigorous analysis and optimization techniques.
Key Responsibilities:
1. SQL Development & Optimization
- Develop, enhance, and maintain complex SQL queries and stored procedures to meet business requirements.
- Analyze and tune underperforming queries using best-in-class optimization techniques.
- Design efficient data retrieval strategies for large-scale, time-sensitive datasets (both real-time and historical).
2. Performance Tuning & Database Optimization
- Perform detailed analysis of SQL execution plans to identify bottlenecks and suggest improvements.
- Implement indexing strategies, partitioning, and schema design changes to optimize query execution.
- Ensure scalable database solutions to support high-volume, low-latency environments.
3. Troubleshooting & Root Cause Analysis
- Diagnose and resolve SQL and database performance issues in collaboration with DBAs, developers, and support teams.
- Proactively address potential performance degradation and implement preventive measures
4. Data Architecture & Platform Understanding
- Work with modern database engines and understand underlying data pipeline architectures (e.g., Plx).
- Support robust, scalable processing of streaming and batch data workloads.
5. Support & Monitoring
- Adhere to SLAs for issue response and resolution, ensuring minimal system downtime.
- Continuously monitor performance and suggest tuning opportunities based on metrics and usage trends. Required
Qualifications:
- Mandatory Technical Skills
- Expert-level SQL knowledge with a deep understanding of query structuring, optimization, and performance tuning.
- Strong expertise in execution plan analysis, indexing strategies, and database performance diagnostics.
- Proven ability to tune high-complexity queries and optimize data access patterns for large volumes of data.
- Experience
- Minimum of 3 years of hands-on experience in SQL development and query optimization for performance-critical systems.
- Experience working with large datasets and real-time/historical data processing systems. • Prior success in resolving complex SQL-related performance bottlenecks.
- Additional Skills
• Strong communication skills and ability to collaborate with cross-functional technical teams.
• Familiarity with support processes, SLAs, and performance monitoring tools.
Be The First To Know
About the latest Sql Jobs in Hyderabad !
SQL Developer
Posted today
Job Viewed
Job Description
We are seeking a highly skilled SQL Developer with deep expertise in SQL query performance tuning and database optimization. This role demands a strong command of SQL and focuses on improving the efficiency and speed of queries, stored procedures, and overall database performance. The ideal candidate will be responsible for ensuring fast, reliable access to both real-time and historical data through rigorous analysis and optimization techniques.
Key Responsibilities:
1. SQL Development & Optimization
Develop, enhance, and maintain complex SQL queries and stored procedures to meet business requirements.
Analyze and tune underperforming queries using best-in-class optimization techniques.
Design efficient data retrieval strategies for large-scale, time-sensitive datasets (both real-time and historical).
2. Performance Tuning & Database Optimization
Perform detailed analysis of SQL execution plans to identify bottlenecks and suggest improvements.
Implement indexing strategies, partitioning, and schema design changes to optimize query execution.
Ensure scalable database solutions to support high-volume, low-latency environments.
3. Troubleshooting & Root Cause Analysis
Diagnose and resolve SQL and database performance issues in collaboration with DBAs, developers, and support teams.
Proactively address potential performance degradation and implement preventive measures
4. Data Architecture & Platform Understanding
Work with modern database engines and understand underlying data pipeline architectures (e.g., Plx).
Support robust, scalable processing of streaming and batch data workloads.
5. Support & Monitoring
Adhere to SLAs for issue response and resolution, ensuring minimal system downtime.
Continuously monitor performance and suggest tuning opportunities based on metrics and usage trends. Required
Qualifications:
Mandatory Technical Skills
Expert-level SQL knowledge with a deep understanding of query structuring, optimization, and performance tuning.
Strong expertise in execution plan analysis, indexing strategies, and database performance diagnostics.
Proven ability to tune high-complexity queries and optimize data access patterns for large volumes of data.
Experience
Minimum of 3 years of hands-on experience in SQL development and query optimization for performance-critical systems.
Experience working with large datasets and real-time/historical data processing systems. • Prior success in resolving complex SQL-related performance bottlenecks.
Additional Skills
• Strong communication skills and ability to collaborate with cross-functional technical teams.
• Familiarity with support processes, SLAs, and performance monitoring tools.
SQL Developer
Posted today
Job Viewed
Job Description
Position Overview:
We are seeking a highly skilled SQL Developer with deep expertise in SQL query performance tuning and database optimization. This role demands a strong command of SQL and focuses on improving the efficiency and speed of queries, stored procedures, and overall database performance. The ideal candidate will be responsible for ensuring fast, reliable access to both real-time and historical data through rigorous analysis and optimization techniques.
Key Responsibilities:
1. SQL Development & Optimization
- Develop, enhance, and maintain complex SQL queries and stored procedures to meet business requirements.
- Analyze and tune underperforming queries using best-in-class optimization techniques.
- Design efficient data retrieval strategies for large-scale, time-sensitive datasets (both real-time and historical).
2. Performance Tuning & Database Optimization
- Perform detailed analysis of SQL execution plans to identify bottlenecks and suggest improvements.
- Implement indexing strategies, partitioning, and schema design changes to optimize query execution.
- Ensure scalable database solutions to support high-volume, low-latency environments.
3. Troubleshooting & Root Cause Analysis
- Diagnose and resolve SQL and database performance issues in collaboration with DBAs, developers, and support teams.
- Proactively address potential performance degradation and implement preventive measures
4. Data Architecture & Platform Understanding
- Work with modern database engines and understand underlying data pipeline architectures (e.g., Plx).
- Support robust, scalable processing of streaming and batch data workloads.
5. Support & Monitoring
- Adhere to SLAs for issue response and resolution, ensuring minimal system downtime.
- Continuously monitor performance and suggest tuning opportunities based on metrics and usage trends. Required
Qualifications:
- Mandatory Technical Skills
- Expert-level SQL knowledge with a deep understanding of query structuring, optimization, and performance tuning.
- Strong expertise in execution plan analysis, indexing strategies, and database performance diagnostics.
- Proven ability to tune high-complexity queries and optimize data access patterns for large volumes of data.
- Experience
- Minimum of 3 years of hands-on experience in SQL development and query optimization for performance-critical systems.
- Experience working with large datasets and real-time/historical data processing systems. • Prior success in resolving complex SQL-related performance bottlenecks.
- Additional Skills
• Strong communication skills and ability to collaborate with cross-functional technical teams.
• Familiarity with support processes, SLAs, and performance monitoring tools.
SQL Developer
Posted today
Job Viewed
Job Description
TECHNOLOGY STACK: SQL, Transact-SQL, SQL Server, AWS, Dynamo DB, RDS, Azure Cosmos, Mongo DB, Performance Tuning
Detailed JD:
The role would be to support one or more databases of low to medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data. Developing and maintaining enterprise data documentation and metadata models along with coding, editing, and installing stored procedures and functions for accessing, maintaining, and populating databases. The Database Engineer will be involved in coding, editing, and installing stored procedures and functions for accessing, maintaining, and populating databases. Implementation of database backup and recovery procedures also maintaining development, production, and multiple testing environments. Understanding the process of resolving a query or incidents. Assisting in configuring and monitoring the back-up processes on all the servers and determining the appropriate course of actions for fixing problems, identifies and mitigates risks, and implements solutions. Troubleshooting databases accessibility, availability or operability problems and conducting Level 2 support. Communicate important information regarding incidents and service requests to concerned stakeholders.
Competencies:
- Understands and meets stated needs & requirements of the stakeholders and work output to truly partner with all concerned stakeholders.
- Takes responsibility for development of self and team; creates long-term development plans and monitors their progress.
- Proactively seeks and supports new ideas and options generated by others.
- Modifies and adapts current methods and approaches to better meet needs.
- Adapts to diverse cultures and ideas to ensure success of projects.
- Acts and responds quickly to stated business, people or stakeholder challenges.
- Identifies problems and draws conclusions by gathering, analyzing, and interpreting quantitative and qualitative information.
- Chooses the best course of action by establishing decision criteria and evaluating alternatives.
- Proactively shares concern for meeting defined goals related to time, quality and budget and takes corrective measures.
- Demonstrates an astute understanding of the other person’s views by asking the right questions at the right time.
- Has ability to take technical decisions on critical design aspects
- Excellent problem solving, collaboration, and communication skills.
Technical Skills:
- 6+ years in Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
- 2+ years in Cloud Database services like AWS Dynamo DB / RDS
- Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
- Install troubleshoot and resolve the SQL Servers/SSRS/SSIS/SSAS and related software to ensure a working interface and effective performance between applications software, systems software, and installed hardware.
- Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance, backups, recovery, Capacity planning and performance monitoring.
- High availability like clustering, log shipping, mirroring, replication.
- Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.
- Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.
- Establishing backup and recovery or replication plans to minimize data loss and system downtime.
- Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
- Maintaining data integrity and security (manage roles and permissions of database users).
- Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.
- Ensures optimal database performance and availability.
- Creation & maintenance of Databases in AWS.
- Hands-on experience with big data application development and/or with cloud data warehousing (e.g., Spark, Redshift, Snowflake, Azure SQL DW, BigQuery) is a big plus.