What are the responsibilities and job description for the SQL DBA position at OpenArc?
OpenArc - Empowering Your Career. As a leading IT staffing firm, we are dedicated to connecting talented professionals with your ideal opportunities. We are currently seeking a qualified SQL DBA to join our client’s organization and contribute to their ongoing success. Job summaryAs a SQL DBA, you will be at the core of our operations, ensuring our database systems are optimized, secure, and scalable. You’ll also work closely with application teams to design and implement API integrations and support our data-driven applications. Responsibilities : Manage and maintain SQL Server databases, ensuring optimal performance, security, and availability.Lead efforts in database tuning, backup strategies, and disaster recovery planning.Collaborate with application teams to integrate databases with various business applications.Troubleshoot and resolve database-related issues in a timely manner.Perform database migrations, upgrades, and patch management.Monitor database performance and provide recommendations for continuous improvement.Develop and maintain documentation for database architecture and processesSome design and implementation of APIs for seamless communication between systems.Some application development and support Requirements : Proficiency in creating, maintaining, and optimizing databases.Strong experience in writing and debugging complex SQL queries, stored procedures, functions, and triggers.Expertise in implementing backup strategies and performing database restores.Knowledge of roles, permissions, encryption, and implementing SQL Server security best practices.Experience with query optimization, index maintenance, execution plans, and troubleshooting bottlenecks.Proficiency in database schema design, normalization, and partitioning.Experience with SQL Server clustering, replication, log shipping, and Always On Availability Groups.Ability to create, deploy, and troubleshoot ETL packages for data imports / exports. (SSIS : SQL Server Integration Services)Ability to build and deploy reports as needed. (SSRS : SQL Server Reporting Services)Proficient in developing, testing, and deploying C# applications using .NET / .NET Core.At OpenArc, we prioritize your career success and strive to build exceptional technical teams for our clients. By understanding your experience and aspirations, we ensure to present you with rewarding and fulfilling opportunities. As an employee of OpenArc and our clients, you will be eligible to participate in a comprehensive benefits package.OpenArc is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
