Hi ,
Hope you are in the best of health & Spirit!
If you are interested in applying for below opportunity, then below are the options.
-> Please send me a copy of updated resume. (You can just reply/attach to this email).
Job Title: MS SQL Database Architect/DBA; - overall 15+ years Mandatory
50% Architect and 50% Admin role
Location: Cincinnati, OH;
Duration: Long term Contract
Mode of Work: Day 1 onsite;
I am also including the Job Description below:
Job Description:
We are seeking a highly skilled and experienced Database Architect and Administrator to join our team. The candidate will have a strong background in both SQL and NoSQL databases, including MS-SQL, PostgreSQL, MongoDB, etc. This role involves designing, implementing, and maintaining database systems to ensure optimal performance, security, and reliability of OPTO Products and Projects.
- Design and implement database architectures for both SQL and NoSQL databases.
- Administer and maintain MS-SQL, PostgreSQL, MongoDB databases.
- Ensure database security, backup, and recovery processes are in place and effective.
- Implement data warehousing best practices to ensure data quality, performance, and scalability.
- Monitor database performance and optimize queries for efficiency.
- Collaborate with development teams to design and implement database solutions that meet business requirements.
- Develop and maintain database documentation, including data models, schemas, and procedures.
- Troubleshoot and resolve database-related issues in a timely manner.
- Conduct regular database performance reviews and provide recommendations for improvements.
- Implement and manage database clustering, replication, and failover strategies to ensure high availability and disaster recovery.
- Develop and enforce database standards, guidelines, and best practices.
- Work closely with the IT security team to ensure compliance with data security policies and regulations.
- Provide technical support and guidance to other team members and stakeholders.
- Design, implement, and test backup, recovery, and disaster recovery procedures with minimal downtime.
- Evaluate and recommend new database technologies and tools to enhance the database infrastructure.
- Manage database access controls and permissions to ensure data integrity and security.
- Perform database migrations and upgrades as needed.
- Create and maintain automated scripts for database maintenance tasks.
- Create and maintain comprehensive documentation for data architecture, ETL processes, and data models.
- Provide training and support to other team members and end-users on data-related best practices and tools.
Requirements
- BS in Computer Science. Masters Preferred.
- 15+ years of experience as a Database Architect and Administrator.
- Strong knowledge of MS-SQL, PostgreSQL, and MongoDB and tools to develop and maintain the databases.
- Self-starter with the ability to investigate and understand business requirements, translate them into technical specifications, and implement the required design.
- Experience with database design, performance tuning, locks, and query optimization
- Experience with database security best practices.
- Experience as a standalone DBA. Willing to work independently, drive critical efforts, and plan and manage work.
- Excellent problem-solving and analytical skills. Strong communication and collaboration skills.
Email ID:
Never miss an opportunity! Create an alert based on the job you applied for.
