BUSINESS INTELLIGENE MICROSTRATEGIES DEVELOPER USING ENTERPRISE DATA WAREHOUSE INITIATIVE!!!!!!

Are you looking for an opportunity to expand and extend your current technical skills into a new industry? Do you want to find new, creative ways to perform database administration? Our client is seeking a Microsoft SQL Server Database Administrator that has technical skills in development and production environments. You will be able to work on various applications that are hosted in a client/server environment. These applications perform the day-to-day mission critical operations for our Dallas headquartered company.

The company has applications that reside on an Oracle Platform, Microsoft platform and combined environments. They utilize MS SQL2000 and SQL Server v2005 enterprise environment. In this role you will utilize your expertise in the design, development and support of multiple client/server applications. This individual will provide senior level expertise in the areas of scoping, analysis, design, development, business process, reporting and performance tuning. The Corporate Information Store contains the legacy data that must manage various operational systems utilizing Oracle and/or SQL Server.

Primary Objective:
The candidate will analyze, develop, implement, support, and document the current databases within the operational OLTP systems and corporate application. Next, take on the development role of defining an overall Database strategy encompassing the enterprise needs, integrating this approach with Microsoft based applications. During first three to six months this includes gaining an understanding of the current environment and business needs, upgrading the current operational databases as specified, and creation of the database data administration standards and procedures.

The candidate we are looking for the organization delivers prompt, accurate, and consistent support for all internal IT development teams and customers. Your role encompasses MS Server, Oracle, UNIX, and network management as well as delivery of technical level satisfaction to meet all customers' established expectations in cooperation with IT Services Managers and other internal teams.

Job Requirements:
As a DBA you will be responsible for various SQL Server Applications as they relate to application and development design. This position is also responsible for working with and guiding development team members to ensure that the physical implementation fulfills the business requirements.

Performing the following duties will carry out these tasks:
* Work with the IT development teams to define new and innovative ways of representing and analyzing data for implementation in the application environments;
* Define data requirements and design associated with the implementation of various IT initiatives;
* Create and maintain database and application requirements and design information working with the Data Modelers utilizing CASE tools and logical models;
* Work with the database and application team members to ensure implementation of the intended design;
* Team with DSS team to ensure delivery of intended business meaning;
* Work with the Data Management group to create data administration QA standards;
* Resolve data issues and facilitating data analysis;
* Provide production support of the existing applications (on call as necessary)
* Daily maintenance and administration of all SQL servers
* First point of contact for tech problem resolution
* Take inbound tech support inquiries via phone, email and voicemail
* Troubleshoot SQL issues within escalation guidelines
* Track and document all support actions through internal ticketing system from initiation to resolution of issue
* Completely and accurately record all change execution information
* Task planning and estimation. Working with project manager in task coordination of data warehouse activities and other I.T. initiatives;
* Escalate all non-tech customer issues to Client Service Managers;
* Collaborate with other internal organizations on actions such as customer hand-off and resolving common issues;
* Participate as a tech resource as needed for customer issue reviews;
* Gain a thorough understanding of assigned applications, with intimate knowledge of the customers' business purpose, operations, systems configuration, and application software environment;
* Stay current and proficient on existing and emerging relevant SQL technology through self-study, company and vendor provided training opportunities;
* Conducting quality assurance walkthroughs;
* Providing status on a regular basis.

REQUIRED TECHNICAL SKILLS:
You MUST possess at least 2 years of experience in the following areas (most recent experience MUST be with SQL Server database administration:

* 7+ years Information Technology experience;
* 3+ years minimum Microsoft Database Administration experience with proven record of successful implementation and support;
* 3+ years of Microsoft 2000 / NT / XP operating systems and environment
* 5+ years experience with RDBMS architecture and SQL development experience;
* Solid background in relational technology, and complex database design;
* Experienced in NT / SQL Server / DTS environment;

MINIMUM TECHNICAL SKILLS
* Experienced in web and client/server deployments;
* Experienced in developing entity-relationship diagrams and the use of automated modeling tools;
* Back up and restore procedures;
* Knowledge of system level tables;
* SQL performance tuning;
* Stored procedures, triggers, T-SQL;
* SQL clustering (active/passive and active/active);
* SQL replication and log shipping;
* Overall understanding of SQL architecture;
* Extensive troubleshooting experience with SQL issues;
* 1+ year of experience using Visual Basic
* Experienced in moving models from logical to physical form;
* Strong verbal and written communication skills;
* Team player a must;
* Task / issue ownership a must;

DESIRED SKILLS
* 2+ years of Oracle v8x, Unix operating systems and environment
* MCDBA certified
* Experienced in defining data transformation rules between source and target systems.
* Experienced in data warehouse / data mart / and ODS applications;

EDUCATION / CERTIFICATION REQUIREMENTS:
* Bachelor's degree in Information Technology or related area preferred
- Certification as a Microsoft Database Administrator MCDBA, a definite plus!
- Microsoft Certified Developer certification, MCSE highly desired
*SQL 2000 certification, desired

Presently our client only accepting US Citizens and Permanent Residents. Candidate must pass a Criminal Background check, credit check, and drug test before entering the assignment. If this position does not fit your criteria, please forward this to someone who you've worked with.

We would like to thank everyone who submits his or her resume for this position. Due to the volume of resumes that we receive, only those candidates selected for interviews will be contacted. r2 Technologies offers a competitive salary with excellent benefits, is an equal opportunity employer and promotes a smoke free & drug free workplace.