M

Database Administrator (SQL Server & PostgreSQL)

Mindlance United State
Visa Sponsorship
Apply
AI Summary

Design, implement, and maintain SQL Server and PostgreSQL databases to ensure data integrity and performance. Optimize queries, monitor systems, and manage migrations with minimal downtime. Requires W2 employment eligibility and open to visa sponsorship.

Key Highlights
Core expertise in SQL Server and PostgreSQL database administration
Database design, performance tuning, and migration with minimal downtime
W2 employment required with visa sponsorship available
Key Responsibilities
Develop and implement database schemas including tables, indexes, views, stored procedures, and triggers
Create conceptual, logical, and physical database designs to meet business requirements
Plan and execute database migrations ensuring data integrity and minimal downtime
Identify and resolve performance bottlenecks, optimize queries and indexes
Monitor database performance and troubleshoot errors to ensure system stability
Implement security measures including user authentication, authorization, and data encryption
Technical Skills Required
SQL Database Administration Performance Tuning
Benefits & Perks
Visa sponsorship available
W2 employment
Nice to Have
Backup and recovery strategies
Data warehousing and business intelligence solutions
Cloud database solutions (AWS RDS)
Data replication and distribution strategies

Job Description


Core Database skillsets using SQL Server and Postgres

Only looking for candidates who can work on W2 . Open for sponsorship as well.


THIS IS NOT A DATA ENGINEER ROLE.


  • 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.


“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

Staff Fullstack Engineer

Programming
23m ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

Jobgether

United State
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

coffeespace

United State

Reliability Monitoring Engineer

Programming
5h ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

Bright Vision Technologies

United State

Subscribe our newsletter

New Things Will Always Update Regularly