Senior Database Architect

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.

Title:

Senior DATABASE ARCHITECT

Need only locals to MN

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

• 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

• 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

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

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

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