Database Administrator with Database Design Expertise

This is a remote position.

Company: Ansys, Inc.
https://www.ansys.com/en-in
Location: Anywhere
Employment Type: Full-time

Job Summary:

We seek a highly skilled and motivated Database Administrator (DBA) with proven experience in database design to join our growing team. The ideal candidate will be responsible for the full lifecycle of our databases, from design and implementation to maintenance, performance tuning, and security. You will play a crucial role in ensuring our data infrastructure's integrity, availability, and efficiency. This role requires a blend of technical expertise, problem-solving skills, and a strong understanding of database design principles.

Requirements

Database Design and Development:

• Design, develop, and implement database schemas, tables, views, stored procedures, and triggers.
  
• Collaborate with developers and business analysts to understand data requirements and translate them into efficient database designs.
  
• Conduct data modelling and create entity-relationship diagrams (ERDs).
  
• Optimize database structures for performance and scalability.
  

Database Administration and Maintenance:

• Install, configure, and maintain database systems (e.g., MySQL, PostgreSQL, SQL Server).
  
• Perform database backups and recovery procedures.
  
• Monitor database performance and troubleshoot issues.
  
• Implement and maintain database security measures, including user access control and data encryption.
  
• Apply database patches and upgrades.
  
• Ensure high availability and disaster recovery capabilities.
  

Performance Tuning and Optimization:

• Analyze database performance and identify bottlenecks.
  
• Optimize SQL queries and database configurations for improved performance.
  
• Implement indexing strategies and query optimization techniques.
  
• Conduct performance testing and capacity planning.
  

Data Integrity and Security:

• Enforce data integrity and consistency through constraints and validation rules.
  
• Implement and maintain database security policies and procedures.
  
• Perform regular security audits and vulnerability assessments.
  
• Ensure compliance with relevant data privacy regulations (e.g., GDPR, CCPA).
  

Documentation and Reporting:

• Create and maintain comprehensive database documentation, including data dictionaries, schema diagrams, and operational procedures.
  
• Generate reports on database performance, usage, and security.
  
• Communicate effectively with non-technical stakeholders.
  

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  
• 5+ years of experience as a Database Administrator with database design experience.
  
• Strong proficiency in MySQL relational database management systems (RDBMS).
  
• Proven experience in database design, data modeling, and schema development.
  
• Solid understanding of SQL and database performance tuning techniques.
  
• Experience with database backup and recovery procedures.
  
• Knowledge of database security principles and practices.
  
• Familiarity with database monitoring tools and techniques.
  
• Excellent problem-solving and analytical skills.
  
• Strong communication and collaboration skills.
  
• Experience with Cloud database services (Azure SQL) is a plus.
  

Preferred Qualifications:

• Relevant certifications in database administration or design.
  
• Experience with scripting languages for database automation.
  
• Experience with database automation tools.
  

Benefits

Additional Information:

This open position is for Ansys Inc., our prestigious client. The benefits will be provided as per their employment terms and conditions.

Ansys, Inc. is an American multinational company headquartered in Canonsburg, Pennsylvania. It develops and markets CAE/Multiphysics engineering simulation software for product design, testing, and operation and offers its products and services to customers worldwide.