Job Description Orgspire Inc is looking for an SQL Server DBA consultant for our Client based in Columbus, Ohio.
The SQL Server DBA is responsible for coordinating changes to computer database, test and implement the database applying knowledge of database management systems. Responsible for planning, coordinating and implementing security measures to safeguard the computer database.
Experience, Skills, Knowledge
2 year technical degree in computer programming or equivalent training required. Bachelor degree preferred
6 to 8 years of work experience required
Verbal and written communication skills, problem solving skills, customer service and interpersonal skills
Ability to work independently & effective Time Managaement is a must
In depth knowledge in SQL, Visual Basic, Oracle, etc
SQL Server – enterprise edition – 2005, 2008
Installation and support of above versions of SQL Server upgrades
Application of SQL Server minor releases and security patches
SQL Server OEM (grid control) – SQL Server Plugin
Database design and layout
Experience on Windows operating systems related to database administration
Enterprise level change management processes and procedures
Orgspire is looking for Senior Oracle Developer/Data Analyst for their State Government client based in Columbus, OH.
Description:This is a replacement position – the ideal situation would be for the new resource to start in a weeks time so that there could be few days of overlap and transition .The individual should have expertise in Oracle Packages/Functions/Procedures etc. Currently the data has been moved from SQL Server to staging area and needs to further migrate from staging to Target utilising functions/packages.
Should have understanding of Data Modelling and Data Architecture and OLTP systems
Writing detail Tech Specs and Knowledge transition to developers
Maintaining and Coordinating Data Mapping and Data Transformation logic
Data Conversion Experience from SQL Server to Oracle
XML concepts and Web Services desired
SQL SERVER BI Developer
The BI Developer is responsible for report development utilizing expert SSAS and SSRS skills. He/she will work with Users, Business Representatives, Business Analysts and Technical Coordinators to clarify requirements, recommend methods, design solutions, develop reporting objects, optimize cubes, document deliverables and test the output. Development will include as much of the report complexity in the lower layers of the BI Solution as is expedient (e.g. Data Warehouse Views first, Cube Formulas second, and Reporting Constructs last).
Key Roles and Responsibilities
Design and develop visually appealing business intelligence using: SSRS, SSAS, Excel, SharePoint, and 3rd-party BI tools
Support organizational decision-making by turning disparate data into concise and actionable information
Design and develop data cubes and reports that utilize those cubes
Mentor project team members to ensure an efficient, self-managed team
Optimize and maintain existing BI functionality while designing and deploying new solutions
Pursue continuous improvement of data quality, standardization of data management processes, efficiency, and quality of service
Develop and maintain technical specifications and end user documentation of assigned projects and analysis
Train process owners to leverage self-service reporting tools and build reports themselves
5+ years of Microsoft business intelligence stack experience
Fluent in the T-SQL structured query language
Proven competency in the MDX multi-dimensional query language
Must have good analytical, conceptual and root cause analysis skills
Extensive knowledge and experience with Data Warehousing and Data Marts
Proficient in the use of Microsoft Office, SQL Server 2008, and Source Control Software