Dedicated Tech Services, Inc. (DTS) is an award-winning IT consulting firm based in Columbus, OH. We now have an opening for a
Sr. Database Architect in Columbus, Ohio.
s and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time.
Direct applicants only, no corp-to-corp candidates, third parties, or agencies, please.
Required Skills and Experience:
8+ years Data analysis/architecture experience in Waterfall and Agile Methodology in various domains (prefer Healthcare) in a data warehouse environment.
Strong knowledge of relational database, Hadoop big data platform and tools, data vault and dimensional model design.
Strong SQL experience (prefer Oracle, Hive and Impala) in creating DDL’s and DML’s in Oracle, Hive and Impala.
Experience in analysis, design, development, support and enhancements in data warehouse environment with Cloudera Bigdata Technologies (Hadoop, MapReduce, Sqoop, PySpark, Spark, HDFS, Hive, Impala, Stream Sets, Kudu, Oozie, Hue, Kafka, Yarn, Python, Flume, Zookeeper, Sentry, Cloudera Navigator) along with Informatica.
Experience in working with Sqoop scripts, PySpark programs, HDFS commands, HDFS file formats (Parquet, Avro, ORC etc.), Stream Sets pipelines, jobs scheduling, hive/impala queries, Unix commands, scripting and shell scripting etc.
Experience in migrating data from relational database (prefer Oracle) to big data – Hadoop platform is a plus.
Experience eliciting, analyzing and documenting functional and non-functional requirements.
Ability to document business, functional and non-functional requirements, meeting minutes, and key decisions/actions.
Experience in identifying data anomalies.
Experience building data sets and familiarity with PHI and PII data.
Ability to establish priorities & follow through on projects, paying close attention to detail with minimal supervision.
Good experience in working with Visio, Excel, PowerPoint, Word, etc.
Effective team player in a fast paced and quick delivery environment.
Required Education: BS/BA degree or combination of education & experience.
Must be able to work remotely initially and then work on site in Columbus, OH when pandemic conditions allow (which could be months from now)
Desired Skills and Experience:
Demonstrate effective leadership, analytical and problem-solving skills
Required excellent written and oral communication skills with technical and business teams.
Ability to work independently, as well as part of a team
Stay abreast of current technologies in area of IT assigned
Establish facts and draw valid conclusions
Recognize patterns and opportunities for improvement throughout the entire organization
Ability to discern critical from minor problems and innovate new solutions
Job Description: We are hiring an experienced Sr. Database Architect to work for us as a direct, W2 salaried or hourly employee, and the selected candidate will work on an engagement for our client. You will:
Participate in Team activities, Design discussions, Stand up meetings and planning Review with team.
Perform data analysis, data profiling, data cleansing and data quality analysis in various layers using Database queries both in Oracle and Big Data platforms.
Eliciting, analyzing and documenting functional and non-functional requirements.
Document business requirements, meeting minutes, and key decisions/actions.
Lead client meetings and sessions with data-driven analysis to clarify requirements and design decisions.
Perform data gap and impact analysis due to new data addition and existing data changes for any new business requirements and enhancements.
Follow the organization design standards document, create data mapping specification document, pseudo codes for the development team(s) and design documents.
Create logical & physical data models.
Review and understand existing business logic used in Oracle and Hadoop ETL platforms to verify against the business user needs.
Review PySpark programs that are used to ingest historical and incremental data.
Review SQOOP scripts to ingest historical data from Oracle database to Hadoop IOP, created HIVE tables and Impala view creation scripts for Dimension tables.
Assist Business Analyst to create Test Plan, Design Test scenarios, SQL scripts (prefer Oracle and Hadoop), test or mockup data, executes the test scripts.
Validate test results and records as well as log and research defects.
Analyze production data issues, report problems and find solutions to fix the issues, if any.
Create incidents and tickets to fix production issues, create Support Requests to deploy code for development team to UAT environment.
Participate in meetings to continuously upgrade the Functional and technical expertise.
Establish priorities & follow through on projects, paying close attention to detail with minimal supervision.
Create and present project plan, project status and other dashboards as necessary.
Perform other duties as assigned.
Why DTS? We’re inclusive; celebrate your role, grow in your position, feel the freedom to explore, trust the commitment, experience the opportunity. We’re growing, and we need great people to grow with us! Simply put, we’re enabled to hire the best. Our Project Delivery, Enterprise Support, Information Security, and Development Services practices are led by DTS consultants who help select our employees and then guide them. What’s in it for you? A collaborative, supportive environment where high standards, quality, and excellence are the norm.
Why Columbus? It has an exciting Information Technology market, a reasonable cost of living, a low unemployment rate, and a strong quality of life! It’s the 14th-largest city in the United States and is home to fifteen (15) Fortune 1000 companies which are all very dependent on IT.
Our Vision: By building a clear sense of purpose and strong relationships within Dedicated Tech Services, the staff and leadership team can then aspire to be the technology service provider whose quality services set the standard by which others are measured and that our clients ask for by name.
Our Benefits: In addition to the opportunity to work for a caring and supportive company, DTS offers health, vision, and dental insurance, a 401K plan, bonus options, and more! Please visit our web site for more information: https://www.dtsdelivers.com
Dedicated Tech Services, Inc. is an Equal Opportunity Employer
The Database Administrator provides the principal capability within the organization to store, organize, and maintain the security of customer and production data.
