What are the responsibilities and job description for the SQL Server Database Architect position at FourthSquare?
Job Description
SQL Server Database Architect
Remote/Dallas, TX
Full time/C2H
Strong experience in-
- Database design and architecture.
- Database structure adjustments.
- Create and maintain SSIS packages.
- Experience documenting standards & best practices
- Experience of Data Warehousing & Reporting
- Experience with Data Visualizations
- SSIS development for ETL (extract, transform and load)
- SSRS development for reporting
- Demonstrated experience designing architectural framework and have relevant MS SQL experience.
- Addressing data feed anomalies and data errors in the databases.
- Experience writing advanced level MS SQL script code to include dynamic code and queries.
- Create database objects - tables, views, stored procedures, functions, etc.
- Previous experience developing using Agile Sprints.
- Previous experience working with workflow and developing workflow.
- Troubleshooting database issues.
- Provide technical expertise to application development teams
- Assist in tuning complex business analytical queries
- Collaborate with data Tech leads and Architects on the logical models and translate into an optimal physical model that performs efficiently under various load profiles
- Hands-on design, development and delivery for Enterprise-level MS SQL Server
- Have excellent SQL Server and Design and development skills – PL/SQL, T-SQL, Stored Procedures, Packages, Triggers, Unix/Linux Shell scripting
- Ability to work independently and also well together as a member of cross-functional teams in a fast-paced Agile environment
- Must be passionate about data and for delivering high-quality data solutions in an agile fashion
- Previous working knowledge in PeopleSoft environments is a plus
- Working in a multi cloud and on-prem hybrid environments is preferred
Best Regards,
Praveen
Software Engineer II (SQL Database)
JBA International -
Plano, TX
Senior Database Architect
The Intersect Group -
Addison, TX
Database Administrator (Oracle, SQL) :: Remote (Addison, TX)
CEDENT -
Addison, TX