Senior Database Developer
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Key Responsibilities:
1. Performance Tuning and Optimization:
Analyze and improve database performance through query optimization indexing strategies database configuration adjustments and resource utilization monitoring.
2. Database Administration and Maintenance:
Perform routine database administration tasks such as backups restores disaster recovery planning index maintenance and database monitoring and SQL Application Jobs maintenance.
3. Database Maintenance:
Maintain SQL Server databases including tables views stored procedures functions triggers and indexes. Create and optimize logical and physical data models.
4. T-SQL Development and Optimization:
Write optimize and troubleshoot complex T-SQL queries stored procedures and functions for high-volume data processing and efficient data retrieval.
5. Documentation and Best Practices:
Create and maintain comprehensive documentation for database designs processes and procedures. Ensure adherence to coding standards and best practices.
6. Cloud Platform Expertise:
Leveraging Azure services for database management including Azure SQL Database Azure Storage and other related services. Understanding and implementing best practices for Azure SQL Database and other Azure data services.
Desired Skills:
- Experience we are looking for 5-8 Years.
- Understand and maintain complex queries stored procedures functions and triggers along with expertise in performance tuning indexing and query analysis.
- Understanding relational database principles data modeling normalization and schema design for efficient and scalable databases.
- Ability to monitor Azure SQL Database performance using Azure Monitor and troubleshoot database-related issues within the Azure environment.
- Database Administration and Security
- Knowledge of database security best practices user management backup and recovery strategies and monitoring database health and performance.
- Azure SQL Database - In-depth understanding of Azure SQL Database including deployment options (single database elastic pools Hyperscale serverless) performance tiers and scaling.
- Azure Tools and Management - Proficiency in using Azure Portal Azure CLI Azure PowerShell and Azure Data Studio for managing and interacting with Azure SQL databases.
Good to have:
- Experience with Extract Transform Load (ETL) processes and data integration techniques potentially using tools like Azure Data Factory or SQL Server Integration Services (SSIS).
- Azure Data Platform Services - Familiarity with other relevant Azure data services like Azure Synapse Analytics Azure Data Lake Storage and Azure Data Factory.
- Azure Networking and Security - Understanding of Azure networking concepts for secure database connectivity and implementing security features like firewalls virtual networks and private endpoints.
Additional Information :
Personal Skills:
- Excellent analytical and problem solving skills
- Excellent verbal and written communication skills
- Ability to articulate and present different points-of-views on various topics related to project and otherwise.
- Eager to learn and continuously develop personal and technical capabilities.
Required Qualifications:
- MCA or Bachelors in Engineering Computer Science or equivalent.
PERFORMANCE APPRAISAL CRITERIA: Eurofins has a strong focus on Performance Management system. This includes quarterly calibrations half-yearly reviews and annual reviews. The KPIs shall be set and may vary slightly between projects. These will be clearly communicated documented during the first 30 days of your joining.
Remote Work :
No
Employment Type :
Full-time
Key Skills
- Databases
- SQL
- Database Development
- PL/SQL
- Microsoft SQL Server
- ssrs
- Database Design
- SSIS
- T Sql
- Sybase
- Data Warehouse
- Oracle
About Company
Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and the environment safer, healthier and more sustainable. From the food you eat to the medicines you rely on, Eur ... View more
