Database Professional Jobs

Job Title: Team Leader - Database Administration Company: BordersGroup Location: Ann Arbor, MI Description: Lead Database team on small to medium projects and activities, schedules and deadlines.Identifies and resolves risks, constraints and validates assumptions. Prepare project plans & estimates, and schedule / allocate resources involving or including the utilization of resources from other teams Manages staff of 2 to 3 Database Administrators, fosters high levels of accountability and monitoring performance on a regular basis Ensure the personal development of software developers: motivate, grow, coach, and mentor. Provide leadership by example. Manages work assignments, ensuring work is appropriately assigned and completed within expected timeframes with a focus on quality Interact with vendors or technology partners for product evaluation, system design, implementation and maintenance Oversee sizing and tuning of databases including ensuring that the proper hardware resources are acquired before implementation of any system and continue to be used appropriately during an applications life cycle Analyze business and user needs and recommend creative solutions Act as a Lead DBA and analyst for complex and technically difficult assignments, collaborate with other teams working on related projects Review and approve test plans, test conditions, and expected test results Prepare and deliver project status reports Support a group of applications, including 24x7 production on-call responsibilities Act as a technical mentor to others, training staff as appropriate Consistently applies and enforces Information Technology software standards and help to establish department specific standards

Job Title: Database Analyst Company: Modis Location: Olathe, KS Description: 3 openings ,'" 6 month contract (Possible full time conversion) GENERAL DESCRIPTION To convert property and real estate data into various internal product platforms. General data conversion, data mapping, system configuration, setup, maintenance and work order completion for internal products. Making corrections and changes to projects based on input and feedback from Management, Project Manager, Customers, and internal QA. WORK EXPERIENCE GUIDELINES One year or more data conversion/data mapping experience. Experience working with MicroSoft SQL server writing and executing queries. Familiarity with relational databases and data concepts. Experience working with XML, XSD and XSLT preferred. Experience with Altova MapForce is a plus. EDUCATION GUIDELINES Associate's or Bachelor's Degree or technical institute degree/certificate in Computer Science, Information Systems or other related discipline. Or equivalent work experience. BREADTH Functions, somewhat independently, under general direction of more senior staff members and/or managers. Generally works on one project at a time as a project team member. Additional Skills: SQL, XML, XSLT, Altova MapForce If you are interested, please forward resume to Register to View

Job Title: Data Architect Company: Location: Kansas City, KS Description: DEPARTMENT OVERVIEW Focus Adknowledge displays highly-targeted advertisements based upon past online actions taken by an individual consumer. The Analytics team goal is to refine its targeting algorithms and expand its behavior database (currently 30TB) to continually improve ad targeting over time. Products and Technology The company has a strong technology infrastructure, consisting wholly of proprietary code developed for the following functions: An advanced behavioral-targeting system running billions of calculations per day using consumer behaviors to predict what type of ad is most likely to trigger a response. An online pay-per-click marketplace located at www.bidsystem.com for advertisers to purchase ads from Adknowledge. A proprietary API known as AdStation, which allows publishers to insert targeted advertisements from Adknowledge into their unsold ad inventory. To support these products the Adknowledge infrastructure consists of: 20 terabytes of data housed in Greenplum (postages) solution 500+ Linux servers LAMP based platform mixed with some C, C++, and Oracle A cloud running Hadoop, DHT, and other distributed services. Data Analytic Team Adknowledge Analytics Department provides a central lab for statistical analysis, machine learning, and distributed computing, to service business needs throughout the rest of our company for targeted consumer advertising. We have a mission to deliver high quality, timely analysis, distill real business insights from large data sets, and provide scalable analytics which the rest of the company consumes on demand. In addition, we assist on studies, metrics, data visualization, system architecture, etc., in other areas of our business. POSITION OVERVIEW The Data architect will be instrumental in driving database changes with large implication for our company?s revenue due to terabytes of cross channel data. The Database Architect is the subject matter expert and directs all database design, integration and maintenance efforts. This position reviews the capability and strategy requirements for on boarding new channels into the data warehouse. The DB Architect?s primary duties consist of: Management of DW: Assists DBA?s with all database administration functions, including access, device allocations, performance monitoring and tuning, permissions, data back-ups, user management, validation checks, organization, security and documentation. Design: Extensive design and implementation experience of various MySQL Oracle, Neteeza, backup/recovery strategies. Data Warehouse Schemas: Responsible to ensure consistent and optimized data schemas. Responsible for creating standard, cross-channel schemas in addition to approving and consulting with channels on channel specific data schemas. Access Management: Centralized ownership of super-user/root access to the system. Data Loading & Validation: Create validation processes for inbound data to data warehouse. As well as, maintain documentation of DB schemas, queries, data inputs, etc. Manage ETL Tool: Manage the setup and changes to the data loading transformations/jobs in a tool such as Pentaho/Kettle. Resource Prioritization: Manage resource queues to ensure business critical, production queries, and prioritized higher than ad-hoc or research queries. Strong hands on experience & skills with SQL or PostgreSQL CANDIDATE OVERVIEW The successful candidate will be a vital addition to the team with at least: Minimum 5 years of technical experience in an Oracle 8i/9i/10g/11g environment. Minimum 5 years of experience in database design/architecture, data modeling, security, performance, scalability, and tuning for high transactional databases. 5+ years of technical experience in a SQL environment. 5+ years of experience as a data architect. In depth experience with High Availability Configurations - Clustering, Replication, Mirroring and Log Shipping. Experience with Map Reduce technologies a plus. Must have good written and verbal communication skills The successful candidate will also demonstrate the following abilities: Passion for Technology: Excitement for new technology, bleeding edge applications, and a positive attitude towards solving real world challenges. Team Player: Work in a highly collaborative environment. This includes evaluating concepts, debating ideas, and helping others move projects forward. Detail oriented: accuracy and attention to detail is very important in this position. Pragmatic: The ability to translate theoretical results into business applications. This includes identifying and understanding the business need, formulating and evaluating possible solutions, completing the exploratory and predictive phases of analysis, and moving the recommended solution into production. Bachelors degree in Computer Science or Engineering, or equivalent experience; Graduate Degree is a plus.

Job Title: SQL 2005/2008 Data Warehouse Developer Company: Location: Minneapolis, MN Description: Our client is looking for Microsoft SQL Server 2005/2008 Developer (relevant 2005 is a must) with deep SSIS experience as well. Strong T-SQL and SQL skills are imperative with SSAS experience a plus. A successful candidate will possess a collaborative mind set with the ability to share ideas and a willingness to code based on the consensus. An all around comfort within multiple IT disciplines is a benefit! Qualified candidates should email resumes to Register to View

Job Title: Facilities CAFM Data Analyst Company: GMAC Location: Minneapolis, MN Description: FACILITIES CAFM DATA ANALYSTThe position can be in either Minneapolis or Detroit.PURPOSE/SCOPEResponsible for the overall data integrity of the GMAC Global CAFM (Computer-Aided Facility Management) system.Responsible for providing first level functional support and training as needed.Ensures to our customers are met in providing analysis and metrics.Responsible for the accuracy and availability of the data both internally and to our key customers.Generates reports as required by our customers.Assists with the design and development of new functionality in the CAFM system for our customers.PRIMARY RESPONSIBILITIES 60% 1. Maintenance of Global CAFM System: Responsible for the data maintenance and upkeep of the overall CAFM system.Ensure that all information contained in the system is up to date and accurate.This includes supporting the MAC/Project Manager with updates to their master AutoCAD files and CAFM information and interfacing with our customers, partners, and key stakeholders.It may also include pulling data from other internal sources and cross checking that information.Provide internal/external support for all types of users of the system (plus training) via the CAFM Support email account.Work directly with ITG partners on issues, support, projects, etc. on a regular basis.25% 2. Technical: Overall maintenance of system facilitates upgrades and all changes to users, coordinate this effort with ITG, 3rd party host and users.Database and website knowledge be able to investigate data and functional issues and facilitate resolution with our 3rd party host and integration provider.Technical writing skills (SQL knowledge) for querying data.15% 3. Analysis and Metrics: Partner with CAFM Team and other key stakeholders as needed to understand business strategies and objectives to provide trend reporting and analysis.Perform regularly scheduled audits & data clean-up.Perform queries that audit the CAFM data and highlight any discrepancies, issues, etc., and work with MAC Managers to resolve. Examples include variance and summary reporting, department and business metrics, and graphic representations of data.Also will manage the archival of historical data.KEY ATTRIBUTESAdvanced skills (verbal, written, listening)Professional customer service skillsDemonstrate ability to handle multiple projects and assignments, able to prioritize, coordinate resources and meet deadlinesMaintain and exhibit a positive, willing attitudeJOB REQUIREMENTSEducation level:Undergraduate degree with related or equivalent work experience and technical seminars. Total years and type of prior related experience:Three to five years work experiences in corporate facilities or technical environment with emphasis on data analytics. Technical (required):Proficiency with MS Office software (Word, Excel, Powerpoint, Outlook, and FrontPage). Technical skills SQL language knowledge for writing/creating queriesSQL Query Analyzer or Toad for SQL database queryingCrystal Reports XI - developing and running reports.Technical (desired):Experience using FM:Systems CAFM Database software and/or other CAFM Database experience.Experience with database integration & interfaces (HR & Financial systems)MS Project - creating/maintaining project plans.Experience using AutoCAD 2008/09 software Reporting relationships:Reports to Global CAFM Manager.

Job Title: Database Administrator Company: Network Health Location: Medford, MA Description: Design, administer and support current and future database development and methodologies. Proactively evaluate the physical and logical design of databases to support our dynamic and growing business needs. Duties include: database backup, database recovery, performance tuning, data integrity, database replication, security administration and modeling of new and existing databases. PRINCIPAL DUTIES AND RESPONSIBILITIES ESSENTIAL FUNCTIONS: 1. Assume primary responsibility for the setup and maintenance of our internal SQL Server databases. 2. Perform routine maintenance and performance tuning on user databases, supporting web transactions, client-server apps and the data warehouse. Monitor for performance issues. 3. Create, test and document custom stored procedures and jobs as required. 4. Serve as data gatekeeper for backend modification to data in all SQL Server systems 5. Manage and perform backup/restore and replication of databases for data recovery and testing. 6. Produce specifications, entity relationship diagrams and data maps as needed for technical documentation. 7. Identify and apply appropriate service packs and updates. 8. Employ SQL Profiler, Database Engine Tuning Advisor, or comparable utilities to monitor server and query processes to assess and optimize databases. 9. Assist with the evaluation of new versions of SQL Server and migration of older systems to current versions of SQL Server. 10. Administer and monitor all database profiles and security. 11. Assist development team with creating efficient queries, stored procedures, jobs, etc. OTHER JOB FUNCTIONS: 1. Work closely with the IT department as a whole to proactively meet SQL Server needs for the business. 2. Work with the Applications and Technical Services team to ensure all systems are configured properly to host SQL databases, both prior to purchase and prior to deployment. 3. Ensure that all applications, databases, and systems comply with state, local and federal security and privacy rules, including HIPAA and Massachusetts Privacy Law. 4. Maintain professional and positive relationship with database services partner. MINIMUM QUALIFICATIONS: Education: Bachelor's degree preferably in Computer Science, MIS, or 3 to 5 equivalent experience Skills/Experience: 5 to 8 years of proven Database Administration experience using Microsoft SQL Server or other RDBMS solutions. SQL Server database experience must encompass: Architecture, Database Design, Referential Integrity concepts, Replication, Mirroring, Security design, Stored Procedures, Triggers, and SQL Server Integration Services (SSIS). Must have a thorough knowledge and understanding of SQL via queries and Stored Procedures. A minimum of 18 months of SQL Scripting. An excellent team player with a professional attitude. Goal-oriented. Ability to work in a fast-paced deadline intensive environment. Solid communication and time management skills. Extreme attention to detail. Error-free results are critical. Extreme comfort in Windows integrated environments, including server OS, server products, active directory, security policy, Powershell, .Net framework and Visual Studios. Pluses: o Knowledge of VB, ASP, and XML. o Experience with Oracle or other variants of RDBMS o Previous healthcare experience o Hands-on Data Warehousing experience. o Certificate/License: MCTS or other related certification How to apply Send your resume with a cover letter to Register to View -health.org . Please include the above Job Code in the subject line of your email. Or, mail them to: Network Health Attn: Human Resources 101 Station Landing Fourth Floor Medford, MA 02155

Job Title: Clinical Data Analyst Company: EmCare, Inc. Location: Clearwater, FL Description: Are you a great independent worker? Are you seeking a great opportunity in healthcare? Answered yes? We have a great opportunity for you! ABOUT EMCARE EmCare is the nation's leading emergency practice management company with extensive resources and superior support programs developed in partnership with hundreds of hospitals and thousands of physicians. Clinical Data AnalystResponsible for providing analytical support and database management with excellent customer service and strict adherence to confidentiality.Essential Duties and Responsibilities: Maintain systems for collection and analysis of clinical performance data and process data into periodic reports for management. Run and distribute regular performance reports that update the organization on clinical aspects of the strategic plan, key performance indicators, and national initiatives; include progress summaries by client and regional levels. Serve as a resource to individual operations in their running of routine local clinical data reports. Manage various assigned projects which may include research, analysis, compiling information, and recommendation actions as needed. In collaboration with regional leadership, establish regular performance reports that update the organization on clinical aspects of the strategic plan, and key performance indicators. Work with operations, IT and clinical data resources (both within and outside of the company) to assure that clinical data is downloaded into clinical databases in a timely and secure fashion. Serve as a consultant to regional operations, divisions, and medical directors in the analysis of specific clinical problems to include: statement of the problem, identification of data elements that might help better understand the problem, establishment of criteria for custom reports, running custom reports and analyzing results. Develop, generate and edit reports on a daily, weekly and monthly basis, as well as preparing any special ad hoc reports required by management. Build reporting mechanisms that demonstrate and track key performance metrics in operational, financial and patient and employee satisfaction areas, as well as any other areas determined by management. Responsibilities: May travel to local operations for meetings related to clinical data and maintaining jurisdictional requirements. Adhere to all company policies and procedures. Perform other duties as assigned.Required Skills: Minimum Qualifications: Education: Associate degree preferred; High School Diploma or GED minimum. Experience: 2 or more years experience in data analysis. Working knowledge in Microsoft Excel and Access with a proven ability to create and maintain databases. Experience in analytical problem solving (including statement of problem, identification and collection of pertinent data, analysis, recommendation, and re-evaluation) strongly.EmCare Cares about employees. We offer competitive TOTAL REWARDS compensation and comprehensive benefits package including: Paid Time Off Medical Plan Prescription drug coverage Dental Vision Life Disability Employee Assistance Program 401k WITH company match Flexible Spending Account TO APPLY: E-mail or fax your resume in Microsoft Word format with refrence SE- CDA Please include salary requirements. Fax to Register to View .

Job Title: Senior Oracle Data Architect Company: Winter, Wyman Location: Universal City, CA Description: Well known television company is seeking a Senior Oracle Data Architect to join their team.The position is located in Universal City, California and the length is for 6 months. Requirements: Built a logical and physical database design of 500+ tables for OLTP and analytical purposes using relational and dimensional modeling Reverse engineered production databases for analysis/re-factor Familiarity with advanced Oracle features including RAC, Oracle Enterprise Manager, compression, materialized views, external tables, partitioning, profiles Developed and used, in production, scripts to implement processes and build/deploy objects including, Unix shells and PL/SQL 5+ years experience Oracle Database Architecture/Administration 3+ years of data modeling and application database design experience 1+ years experience with ERwin ERD tool to model, generate scripts and compare models with physical databases Finding and fixing performance issues Bringing order to complex and ambiguous situations Creating metadata-driven reusable database components in complex shared infrastructures Problem escalation procedures to Oracle Development team and third parties Capacity and performance planning of memory, CPU, disk space, and I/O If you are already working with a Winter Wyman recruiter, please contact them directly; otherwise, please send your resume and contact information to Register to View .

Job Title: Oracle Database Developer(DB2) Company: iFuturistics Inc Location: Raleigh, NC Description: DB2 to Oracle Data conversionThe individual will be an experienced technical resource with SQL programming experience and working knowledge in Oracle and DB2 databases. The individual should be able to provide training to the less experienced members of the team. The individual will work closely with the technical leads and functional team providing the integration solution. Project responsibilities will include:- Develop technical processes to facilitate infrastructure development across multiple platforms- Analyze client and product requirements to design, develop and document solutions- Assist the team lead in the development, configuration and deployment of the integrated solution- Review the code and tools developed by other team members.- Provide training/guidance to junior members of the team

Job Title: Sr Database Administrator Company: Advertising Specialty Institute Location: Trevose, PA Description: ASI's Internet Programming division seeks an individual with strong Database/Data warehouse design and data analysis skills in mainly SQL Server environment to join their dynamic team. This is not a production DBA position. Required Skills: - Strong skills in logical transactional database, data warehouse design, data modeling and integration. - Strong data analysis skills - Strong knowledge of ETL processes and strong back end ETL implementation skills - Ability to write complex stored procedures for applications and back end processes - Experience with one of programming or scripting languages - Strong database performance analysis and ability to write well performing SQL code - At least 2 years of SQL Server experience - Physical database design - Ability to manage multiple projects at the same time Additional preferred skills: - SQL Server database administration - Stored procedures troubleshooting and tuning - Ability to operate as a team player and independently - SQL Server development and production support skills We are proud to be an EEO/AA employer M/F/D/V.