Design and implement database schemas, ensure data integrity, and optimize database performance. Develop and maintain efficient SQL queries and stored procedures. Collaborate on database migrations and ensure high availability.
Key Highlights
Key Responsibilities
Technical Skills Required
Benefits & Perks
Job Description
Core Database skillsets using SQL Server and Postgres
Only looking for candidates who can work on W2 . Open for sponsorship as well.
- Database Design and Implementation:
- Conceptual, Logical, and Physical Design: Developing and implementing database schemas, including tables, indexes, views, stored procedures, and triggers to meet business requirements and ensure data integrity.
- Data Modeling: Creating data models that represent the structure of the data, relationships between entities, and how data will be stored and accessed.
- Table partitions and archiving.
- Database Migration: Planning and executing database migrations ensuring data integrity and minimal downtime.
- Database Administration and Maintenance:
- Performance Tuning: Identifying and resolving performance bottlenecks, optimizing queries, indexes, and database configurations to improve query execution speed and overall system efficiency.
- Monitoring and Troubleshooting: Continuously monitoring database performance, identifying and resolving issues, troubleshooting errors, and ensuring system stability and availability.
- (Optional) Backup and Recovery: Implementing and managing backup and recovery strategies, including regular backups, disaster recovery plans, and data restoration procedures to ensure data availability and prevent data loss.
- (Optional) Security Management: Implementing and enforcing security measures, including user authentication, authorization, access controls, and data encryption to protect sensitive data from unauthorized access and breaches.
- (Optional) Data Integrity and Quality: Implementing procedures and checks to ensure data accuracy, consistency, and validity, including validation rules, data cleansing, and data quality monitoring.
- Database Development and Support:
- SQL Development: Writing efficient and optimized SQL queries, stored procedures, functions, and triggers to perform data manipulation, retrieval, and analysis.
- (Optional) Database Scripting: Creating and maintaining scripts for database administration tasks, including database creation, schema changes, data loading, and automated backups.
- Advanced Database Technologies:
- High Availability and Disaster Recovery: Implementing and managing high availability solutions, including database mirroring, log shipping, and Always On Availability Groups, to ensure continuous database availability.
- (Optional) Data Warehousing and Business Intelligence: Designing and implementing data warehouses, data marts, and business intelligence solutions to support data analysis and reporting.
- (Optional) Cloud Database Solutions: Understanding and implementing cloud-based database solutions, including AWS RDS, to leverage cloud infrastructure and scalability.
- (Optional) Data Replication and Distribution: Implementing data replication and distribution strategies to ensure data consistency across multiple databases or locations.
Searching for IT & Network Engineering roles that provide visa sponsorship? Connect with international employers through IT & Network Engineering Jobs with Visa Sponsorship opportunities actively seeking talented professionals.
Explore our comprehensive directory of visa sponsorship jobs from employers worldwide who are ready to sponsor talented international professionals.
Interested in opportunities specifically in United State? Discover our dedicated Visa Sponsorship Jobs in United State page featuring roles from top employers in this location.
“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”
Similar Jobs
Explore other opportunities that match your interests