Paradigm Infotech
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 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 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
Mandatory Details: 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) #J-18808-Ljbffr
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 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 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
Mandatory Details: 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) #J-18808-Ljbffr