Title: Senior DATABASE ARCHITECT
Location : Chanhassen, MN
Duration : 3 plus months
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
1. Produces database schemas and changes based on developer provided data requirements, including creating tables, indexes, views, triggers and storage procedures
2. Initiates database change request process on all database related changes and verify Database Team is following SOX compliance guidelines
3. Oversee database change request process on all database related changes, review SQL code for Data Architects, and provide formal approval
4. Support creation of ad hoc queries for the business and technical teams as needed
5. Determine application database access security and follow formal approval process
6. Monitors the growth of production databases to determine future capacity needs and upgrades
7. Produces technical and functional data dictionaries and diagrams of systems
8. Produces scripts to convert data for system migrations and upgrades
9. Assists software development groups with database related issues
10. Oversee performance tuning and optimization of all databases servers
Other Duties
1. Follow SQL coding standards
2. Verify compliance standards are followed on database servers
3. Review and approve SQL scripts for other Data Architects
4. Provide database technical consulting to Data Warehouse Architects, IT, and the business
5. On-call support on a rotating schedule
6. Provide technical leadership and supervision to Database Team
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
Javascript
Experience with Informatica or similar ETL tool
Experience with Cognos BI Framework Manager and Transformer
Mandatory Details:
Full Name as per SSN:
Total Experience:
US Experience:
Contact NO:
Email ID:
Current work authorization in US:
Current Location with city:
Relocation:
Availability:
Last 4-digits of SSN:
Skype Id :
Educational Details :
Rate(C2C/1099/W2):
Employer:
2 Official references from recent 2 projects in below format (Must)
Reference 1
Name:
Company name:
Designation:
Official mail id:
Contact Details:
Reference 2
Name:
Company name:
Designation:
Official mail id:
Contact Details:
Job details are sourced from the employer's original posting.
Open job postingAbout the company
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.