Database Administrator with Database Design
- Kpr sugar apperals
- 5 to 9 Yrs
- All India
- 3 months ago
- Email to a friend
- Report this job
Job Description
- 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.,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Not Specified
Functional Area: Not Specified
Role/Responsibilies: Database Administrator with Database Design
Contact Details:
Company: NetConnect DigitalLocation(s): All India
+ View Contact
Keyskills: Database Design Database Development SQL Performance Tuning Database Administration Database Maintenance Data Security Documentation Reporting
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in