Senior DATABASE ARCHITECT

Paradigminfotech; Chanhassen (MN); On-site; USD 90,000 - 120,000; Full time

Job summary

A global IT solutions provider is seeking a detailed-oriented Senior Database Architect in Minnesota. This position includes designing and developing SQL schemas, performance tuning, and ensuring compliance with SOX guidelines. Candidates should have at least three years of experience in MS Transact SQL and two years in database design. The role offers a dynamic environment with technical leadership responsibilities and a rotating on-call schedule. Strong general programming skills and MS Office knowledge are essential.

Qualifications

• Minimum two years of experience in Database Design.
• Minimum three years of experience in MS Transact SQL.
• General programming skills required.

Responsibilities

• Design and develop stored procedures and database SQL schemas.
• Oversee performance tuning and optimization of all database servers.
• Monitor the growth of production databases for capacity needs.

Skills

Database Design

MS Transact SQL

General Programming Skills

MS Office (Outlook, Word, Excel)

Tools

UNIX

Informatica or similar ETL tool

Cognos BI Framework Manager and Transformer

Job description

Paradigm Infotech. Inc is a global IT solutions provider focused on delivering customer value through high Quality Processes and Cost-efficient solutions. Paradigm has been one of the trendsetters in global delivery practices with our Client-Centric Model for customer management and delivery.

Job Description

Title: Senior DATABASE ARCHITECT

Need only locals to MN

Position Summary

Support the Database Team by designing and developing stored procedures, creating database SQL schemas and general performance tuning.

General Duties and Responsibilities

Database Development

• Produces database schemas and changes based on developer provided data requirements, including creating tables, indexes, views, triggers and storage procedures
• Initiates database change request process on all database related changes and verify Database Team is following SOX compliance guidelines
• Oversee database change request process on all database related changes, review SQL code for Data Architects, and provide formal approval
• Support creation of ad hoc queries for the business and technical teams as needed
• Determine application database access security and follow formal approval process
• Monitors the growth of production databases to determine future capacity needs and upgrades
• Produces technical and functional data dictionaries and diagrams of systems
• Produces scripts to convert data for system migrations and upgrades
• Assists software development groups with database related issues
• Oversee performance tuning and optimization of all databases servers

Other Duties

• Follow SQL coding standards
• Verify compliance standards are followed on database servers
• Review and approve SQL scripts for other Data Architects
• Provide database technical consulting to Data Warehouse Architects, IT, and the business
• On-call support on a rotating schedule
• Provide technical leadership and supervision to Database Team

Qualifications

Required Skills

• Database Design (minimum two years experience)
• MS Transact SQL (minimum three years experience)
• General Programming Skills
• MS Office (Outlook, Word, Excel)

Nice to Have Skills

• UNIX
• Experience with Informatica or similar ETL tool
• Experience with Cognos BI Framework Manager and Transformer

Additional Information

• Full Name as per SSN:
• Total Experience:
• US Experience:
• Contact NO:
• Email ID:
• Current Location with city:
• Relocation:
• Availability:
• Last 4-digits of SSN:
• Skype Id :
• Rate(C2C/1099/W2):
• Employer:
• 2 Official references from recent 2 projects in below format (Must)