RiseIT™ Solutions
Location
Delhi | India
Job description
Responsibilities: ·
Administer, monitor, and maintain databases, with a focus on Microsoft SQL Server and Postgres. · Optimize database performance, ensuring high availability and reliability. · Plan and execute seamless data migrations from Microsoft SQL Server to NoSQL databases. · Handle the migration of MS SQL databases to Postgres, ensuring data integrity and minimal downtime. · Demonstrate strong skills in writing complex SQL queries, stored procedures, and triggers. · Conduct performance tuning and optimization of SQL queries for efficient database operations · NoSQL Expertise: • Have in-depth knowledge of NoSQL databases, such as MongoDB, Cassandra, or Couchbase. · Design and implement NoSQL database solutions based on project requirements. · Security and Compliance: • Implement and enforce security best practices for databases. · Ensure compliance with data protection regulations and industry standards. · Collaboration: • Collaborate with development and infrastructure teams to address database-related requirements. · Provide support and expertise during the development lifecycle · Implement robust backup and recovery strategies to prevent data loss. · Conduct regular testing of backup and recovery procedures. Qualifications: • Bachelor’s degree in Computer Science, Information Technology, or related field. • 5+ years of experience as a Database Administrator. • Proficiency in Microsoft SQL Server administration and performance tuning. • Strong skills in writing complex SQL queries and stored procedures. • Experience with NoSQL databases such as MongoDB, Cassandra, or Couchbase. • Familiarity with Postgres database administration and migration. • Knowledge of data migration tools and methodologies. • Understanding of database security and compliance requirements. • Excellent problem-solving and troubleshooting skills. • Strong communication and collaboration abilities. Preferred Qualifications: • Certifications in database administration or related fields. • Experience with cloud-based database solutions (e.g., AWS RDS, Azure SQL Database). • Familiarity with containerization technologies (Docker, Kubernetes).Job tags
Salary