Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Database Architect

Expired Job

Tews Company Orlando , FL 32835

Posted 3 months ago

Tews is currently looking for a Data Architect to join our clients growing team based in Orlando.  The ideal candidate will have a combination of experience with OLTP and Data Warehousing. This position requires OLTP Data Modeling experience.
Big Data and Spark experience is a plus.

Job Responsibilities: 	
Focus on application modernization from a data standpoint. 	
Create target state data models for modern applications. 	
Analyze current applications and collected requirements and create a logical/physical data model. 	
Create migration scripts/packages to move data from legacy system to the modernized version. 	
Incorporate new data domains into existing data warehouse environment. 	
Creating new Fact tables to support business reporting requirements.
Required Experience: 	
OLTP Data Modeling 	
Experience with Erwin or similar data modeling tools is required to create Entity Relationship Diagrams. 	
Knowledge of Entity Framework and .NET is a plus. 	
5+ years’ experience with SQL Server and strong understanding of MS data platform is required. 	
Strong knowledge of Kimball Data Warehouse methodology. 	
Understanding of modern platforms including Spark is a plus.
 
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oltp Database Engineer

NBC Universal

Posted 1 week ago

VIEW JOBS 12/5/2018 12:00:00 AM 2019-03-05T00:00 Responsibilities The OLTP Database Engineer III participates in the design, development, implementation, review, and monitoring of all database environments. The OLTP Database Engineer III works closely with the software development team, the OLAP team, and the QA team to ensure that each has the environments needed to run efficiently and effectively and to provide guidelines and recommendations on best practices in the field. Responsibilities * Design, implement, maintain, and monitor database servers in production, stage, RC, DR, BC, QA, and development environments. * Ensure high availability and meet SLAs for production systems. * Design and implement monitoring solutions to achieve HA and SLA goals as set by the director. * Monitors and audits corporate DBAs during: change planning, scheduling, tracking, implementation, and follow-up. * Reviews and audit all environments for best practices in security. * Responsible for the lifecycle of TSQL development (check-in, review, build, testing, and deployment). Including automation where appropriate. * Drafts documents with TSQL coding guidelines for developers. * Assist developers in best practices for writing queries / procedures. * Performs tuning in production to identify performance bottlenecks. * Ensure future capacity planning and data system performance in expected tolerances. * Designs, develops, and implements ETL jobs based on business requirements. * Creates and implements new environments based on the needs of the business. * Evaluates new acquisition data systems. Designs and implements plans for assimilation. * Designs and implements data systems integration. * Works closely with the Director of Data Services through preparation of reports, emails, and correspondence. * Manages transactional database engineers. Qualifications/Requirements * Eight years and above of hands on SQL Server transactional experience. * Expert knowledge of all aspects of SQL Server Transact SQL. * Profound understanding of SQL Server high availability and disaster recovery technologies, such as backups and restores, log shipping, mirroring, and replication. * SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etc. * Extensive experience in SQL performance analysis and optimization (tuning / optimization). * In-depth knowledge of tuning SQL Server to achieve the maximum performance possible. * Profound understanding of SQL Server concurrency features, transactions, and locking. * Excellent data modeling and schema design skills, including normalization and de-normalization. * Strong experience with SQL Server debugging and tracing. * In-depth knowledge of ETL methodologies. * Experience using full text search and XML in SQL Server. * Full grasp of the pros and cons of table partitioning and distributed partitioned views. * Strong familiarity with data access technologies and protocols, such as ODBC, OLEDB, ADO.NET, LINQ to SQL, Entity Framework, JDBC, Hibernate/NHibernate, etc. * Strong familiarity with SQL Server Service Broker, MS Sync Framework, and Master Data Service. * Strong familiarity with BI technologies, such as ETL, data warehousing, SSAS/OLAP, data mining, and big data technologies. * Strong familiarity with .NET, C#, and CLR objects. * Experience using Microsoft TFS to maintain source control and deployment scripts of all DB objects highly preferred. * Bachelor degree, preferably in Computer Science or equivalent. NBC Universal Orlando FL

Database Architect

Expired Job

Tews Company