SQL Database Developer

We have partnered with a client of ours here in Austin, Texas who is looking to add a talent SQL Server Database Developer to their team!

What you get to go do in this exciting role :

• Ownership of Database Design in a Software Development Environment : Responsible for leading and managing the database design process, ensuring it aligns with the software development needs.
• Data Capacity Planning : Analyzes and plans for anticipated changes in data capacity requirements, ensuring databases can handle future growth.
• Development of Data Standards and Policies : Develops and administers data standards, policies, and procedures to maintain data integrity and compliance.
• Data Conversion and Migration : Develops and implements tools for data conversion and migration to support system upgrades and data integration.
• Collaboration with Financial Planning & Analysis : Works closely with the Financial Planning Analysis team to explore and define report metrics, ensuring accurate and meaningful data reporting.
• Support for Data Access and Warehousing Programs : Supports teams in developing and implementing data access and data warehousing programs to facilitate data storage and retrieval.
• Evaluation of Database Technologies : Evaluates and provides recommendations on new database technologies and architectures to ensure the best solutions are utilized.
• Information Security Assurance : Ensures the rigorous application of information security / information assurance policies, principles, and practices in the delivery of data management services.
• Database Maintenance and Performance Tuning : Assists with maintaining, monitoring, and performance tuning / optimizing databases to ensure high performance and reliability.
• Cross-Functional Communication : Communicates effectively cross-functionally, serving as a bridge between technical and non-technical audiences in conversations.

What you need to be successful in the role :

• Experience in of experience in database administration of SQL Server database environments.
• Knowledge of Microsoft SQL Server : Expertise in Microsoft SQL Server 2014 / 2016 / 2019.
• Understanding of Relational Databases and T-SQL : Thorough understanding of relational databases, T-SQL, scripting, database normalization best practices, and database technologies and concepts.
• Advanced Database Concepts : Understanding of topics like cardinality, parallelism, and parameterization.
• SQL Development Proficiency : Proficient in SQL development, including writing and troubleshooting SQL code and scripts (stored procedures, functions, tables, views, triggers, indexes, constraints).
• Troubleshooting and Performance Tuning : Experience in troubleshooting and resolving database integrity and performance issues, as well as performance tuning and query optimization.
• Experience with SQL Server Services : Experience with SSRS, SSIS, or SSAS.

Educational Background

Degree in computer science or related field.

Preferred Skills

Educational Background

Degree in computer science or related field.

• Advanced SQL Server Experience : Experience in Microsoft SQL Server replication and partitioning.
• Data Warehouse / Data Lake Design : Experience working and designing Data Warehouses / Data Lakes.
6 days ago