What are the responsibilities and job description for the Database Administrator position at CoStrategix?
Database Administrator
The Database Administrator at Costrategix will be responsible for the design, implementation, operation, and maintenance of all aspects of database infrastructures. This includes but is not limited to design, standardization, security, replication, and backup/recovery strategy. This role acts as a Technical Reference User for other designated applications to ensure tools are fully leveraged.
You will play a critical role in ensuring the reliability, security, and performance of databases, contributing to the overall success of IT systems and business operations of CoStrategix customers. A strong understanding of database management systems, data modeling, and a range of technologies associated with database administration is needed for this position.
The ideal candidate for the Database Administrator position will possess a combination of technical expertise, problem solving, and effective communication abilities. They will have a strong understanding of Database Management Systems (DBMS), proficient in SQL for database querying and manipulation, and familiarity with database design, data modeling, and normalization techniques.
Roles and responsibilities:
- Build database systems of high availability and quality depending on each end user’s specialized role
- Design and implement databases in accordance to end users’ information needs and views
- Define users and enable data distribution to the right user, in appropriate format and in a timely manner
- Use high-speed transaction recovery techniques and backup data
- Minimize database downtime and manage parameters to provide fast query responses
- Provide proactive and reactive data management support and training to users
- Determine, enforce, and document database policies, procedures, and standards
- Perform tests and evaluations regularly to ensure data security, privacy, and integrity
- Monitor database performance, implement changes, and apply new patches and versions when required
- Build and maintain ADF pipelines
- Extensive knowledge of ETL/ELT processes
- Be able to assist developers with slow query tuning and troubleshooting of PowerBI reports.
- Provide design, planning, configuration, documentation, deployment, and support ownership of SQL Server/Linux infrastructure
- Install, manage, and customize server configurations of Commercial Off –the-Shelf (COTS) software to achieve mission performance requirements by providing quality work
- Consult with internal departments to identify customer needs and include into project and support objectives
- Communicate effectively and efficiently with all stakeholders
Requirements:
- 6 years of experience as a database administrator/engineer or in a related field
- Bachelor’s degree in computer science, information systems, or related information technology field
- Experience with database standards, design, documentation, coding, and end user applications
- Experience with DBA case tools (frontend/backend) and third-party tools
- Experience with programming languages (T-SQL, Powershell, Unix, etc.)
- Experience with full Azure Stack (Azure SQL DB, ADF, etc.)
- Experience with SSIS, PowerBi, ADF, and other tools from MS stack
- Excellent knowledge of data backup, recovery, security, integrity, and SQL Server
- Excellent problem-solving skills and ability to think algorithmically and explain complex ideas in simple terms
- Ability to work with data architects and other IT specialists to set up, maintain, and monitor data networks
Since 2006, CoStrategix has defined and implemented digital transformation initiatives, data & analytics capabilities, and digital commerce to Fortune 500 and mid market customers. CoStrategix brings thought leadership, strategy, and full end-to-end technology execution for organizations to transform and stay competitive in today’s digital world.
As a Gixer (employee) at CoStrategix, you will have broad exposure to diverse industries and technologies. You will work on leading-edge digital projects in areas of Data Science, AI, Cloud, Mobile, and Application Development & Modernization in an Agile process setting. Gixers operate at the leading edge of technologies and our projects require compelling human interfaces.
We make CoStrategix an awesome place to work with a total rewards package that includes comprehensive benefits starting at day 1. Benefits include: medical, dental, vision, disability & life insurances, EAP and 401(k) retirement. We offer a flexible hybrid workplace committed to a culture of curiosity, collaboration, learning, self-improvement, and last, but not least, fun. We have been named a finalist for the Cincinnati Business Couier’s Best Places to Work Awards for 4 consecutive years.
Do the Right Thing. Always.
At CoStrategix, we are passionate about our core values. Diversity, equity & inclusion (DE&I) are part of our core values Every Gixer (employee) has an opportunity for success regardless of their race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Creating an environment where everyone, from any background, can do their best work is the right thing to do.