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

We are seeking a local candidate in 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 verifies Database Team is following SOX compliance guidelines
• Oversees database change request process on all database-related changes, reviews SQL code for Data Architects, and provides formal approval
• Supports creation of ad hoc queries for the business and technical teams as needed
• Determines application database access security and follows 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
• Oversees performance tuning and optimization of all database servers

• Follows SQL coding standards
• Verifies compliance standards are followed on database servers
• Reviews and approves SQL scripts for other Data Architects
• Provides database technical consulting to Data Warehouse Architects, IT, and the business
• Provides on-call support on a rotating schedule
• Provides technical leadership and supervision to the Database Team

Required Skills:

• Database Design (minimum two years of experience)
• MS Transact SQL (minimum three years of 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