Hello, Client is looking to hire a SQL Server DBA's starting on Jan 10th. They are converting/upgrading 36 servers from SQL Server 2000/2005 to 2008. Phone screen, F2F, decision.
SQL SERVER DBA CHICAGO IL Interview : 1 PHONE , 1 ONSITE LOCAL CANDIDATES ONLY (WITHIN 200 Miles) 1. SENIOR DATABASE ADMINISTRATOR JOB SUMMARY The Database Administrator's role is to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability at TTX. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Responsibilities also include analyzing, re-engineering, automating, and administering a wide range of database servers and their database environments. These Environments may include Development, Test, staging, QA, Backup and Recovery and Production. The person will have to maintain an understanding of the TTX applications and the business functions that utilize these environments. S/he will need strong practical skills in technologies such as Microsoft SQL Server, 2000, 2005 and 2008. Additionally skills required include expertise in tuning T-SQL and database structures, XML data stores, SQL Server functions and utilities and ancillary products which included SSIS, SSRS and SSAS. Success will result in a significant transformation of day-to-day requirements of this and other positions through ongoing analysis of database requirements and workflow processes. DESCRIPTION OF POSITION · Assess the current data architecture and develop short and long-term goals for supporting TTX business users and the corporate data needs in operational and data analysis and data warehousing. · Provide a focal point for communication with the business users on the status and viability of the existing data environment to support on-going and predicted business needs. · Develop and maintain corporate enterprise data models at the logical and physical levels. · Document data usage and flow requirements and develop value asset management procedures for the organization. · Document internal and external data interfaces and support the adoption of common industry standards to the development of interfaces. · Map data from internal and external locations and develop reference, mapping and profiling documentation for the data. · Recommend data architecture component acquisition opportunities based upon enterprise data needs in conjunction with business and IT management. · Design and develop a data movement support infrastructure that supports the corporate goals for data movement and availability within the organization and complies with the overall IT architecture. · Develop data movement and sharing approaches to support the corporate goal of real-time data interchange between operational and analytical components in the data architecture. · Develop corporate data security standards and participate in data security audits. · Work with business users and application development staff to develop and promote knowledge of the corporate data architecture, data quality, data retention and protection standards. · Work with PMO, QA and Development staff to develop architectural, review disciplines into the change control and testing processes. · Resolve issues where project goals conflict with the corporate data architectural goals. · Monitor performance of corporate systems to ensure that targets for data availability, loading and reporting are met. · Work with development teams to improve timeliness of data delivery, quality and availability. · Design and implement redundant systems, policies, and procedures for data disaster recovery and data archiving to ensure effective protection and integrity of all corporate data assets. · Participate in corporate planning sessions to ensure that the physical data storage and support infrastructure can support plans for corporate growth. · Participate in planning and scheduling of data maintenance activities with data management and administration staff. · Conduct research and make recommendations on industry data architecture trends and standards. · Participate in overall business contingency and recovery planning activities. QUALIFICATIONS REQUIRED · 7+ years information technology experience is required. · 5+ years combined experience installing, configuring, and securing SQL Server 2000, 2005 and 2008. · B.A. or B.S. required, a degree in a related area (Computer Science, Computer Engineering, Information Technology) is a plus · Strong understanding of Microsoft SQL Server database, analytical and reporting structures, theories, principles, and practices. · Significant experience in the development of data extraction and load processes in a heterogeneous platform environment (Data Delivery). · Data base design using Normalization and Star and Snowflake approaches. · Hands-on data audit and forensics troubleshooting experience. · Expert in database backup and recovery processes and procedures. · Excellent verbal and written skills Strong technical documentation skills. · Good interpersonal skills. · Ability to conduct research into database issues, standards and products as required. · Ability to present ideas in user-friendly language. · Highly self motivated and directed. · Keen attention to detail. · Proven analytical and problem-solving abilities. · Ability to effectively prioritize and execute tasks in a high-pressure 24X7 environment. · Strong customer service orientation. · Experience working in a team-oriented, collaborative environment. PLUSES · Relevant certifications (MCDBA, etc.) are a big plus. · Knowledge of or experience with web service technologies a big plus. · Experience defining, writing, and publishing corporate policy statements · Experience tuning LINQ database calls · Knowledge of ADO.NET<http://ado.net/> and .NET Frameworks · Knowledge of Service Oriented Architectures Regards Santosh Bhonsley Infomatics Inc., AN INC 500|5000 COMPANY 31313, Northwestern Hwy, Suite 219, Farmington Hills, MI - 48334 | Desk: 248 865 0300 Ext: 12 | Cell: 248 252 1742 Fax: 248 865 0058 Email: [email protected]<mailto:[email protected]> | Web: www.infomatinc.com<http://www.infomatinc.com/> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ This e-mail is intended only for the named recipient(s) and may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. No waiver of privilege, confidence or otherwise is intended by virtue of communication via the internet. Any unauthorized use, dissemination or copying is strictly prohibited. If you have received this e-mail in error, or are not named as a recipient, please immediately notify the sender and destroy all copies of this e-mail. -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/us_itgroups?hl=en.
