Hello Greetings From,
IDC Technologies Inc. Any interest in following position. Title : MYSQL DBA! Location : Miami FL Duration : 6+ months *US Citizen, GC Holder, EAD or TN Visa.* *Job Description* : Candidate MUST have ideally worked with MYSQL version 5.0 or higher. Experience designing relational database with MYSQL Cluster 6.0 or higher. They must have worked writing and analysing complex store procedures and functions on MYSQL database. They ideally should have knowledge of how MySQL uses indexes for queries and table optimizations. They need to be familiar with MySQL functions and operators. Agile experience as well. The Sr. Data Developer will be, extracting, transforming, and loading data from various sources (external and internal) into the data warehouse, develops, documents, implements, maintains, and enforces the comprehensive data strategy, standards, and processes. Designs, constructs, and tests data structures and solutions. • Develop data mappings in SSIS, reports in SSRS for Dashboard • Leveraging SQL Analysis Services to develop advanced analytics components and services to be used in Dashboard. • You will be writing various components in SSIS for advanced data formatting and rules injection. • You will be developing the Enterprise Relational Data store for several applications. • Corresponding Data Access Adapters (Stored Procedures, SQL Views). • Develop and design database objects, tables, views, indexes, constraints, etc. • Analyze query execution plans and optimize database code. • Define and implement data validation processes to ensure data accuracy Other responsibilities may include: • Produce a detailed functional design and architectural document to match customer requirements • Create stored procedures and functions to incorporate complex database algorithms. • Write and understand complex SQL queries for MS SQL, MYSQL, and NoSQL databases. • Define, document, and develop new or maintain existing interfaces between applications, databases, and third party systems to meet business requirements. • Perform ad-hoc analysis of production data where necessary to develop solutions to reported incidents. • Effectively communicate with the appropriate internal and external business and technical customers for information gathering and follow up. • Designing & Maintain schema and databases for MySQL, MS SQL, and NoSQL. • Other duties as assigned and modified at manager’s discretion KNOWLEDGE, SKILLS AND ABILITIES: • Fluency with relational databases, including structure design, ad-hoc SQL queries, and stored procedures. • Experience in relational database design, optimization and performance with commercial-grade databases such as MySQL. • Experience with data dictionaries, data analysis and relational databases • Familiarity with ERD tools (Erwin, data modelers) • Ability to create conceptual, logical, physical data designs. • Ability to effectively query various database platforms to extract required information. • Proven understanding of SQL optimization (Proper indexing and ability to interpret execution plans). • Ability to understand business requirements and convert them into database designs • Proven ETL development skills (SSIS, Informatica, or equivalent ETL tool). • SSIS and/or Informatica development skill a definite plus. • Proven data modeling skills. • Fluent in English education / SPECIALIZED KNOWLEDGE requirements: • Bachelor of Science in Computer Science, MIS, or Mathematics Bachelor Degree. • 5+ years ETL (Extract, Transform, Load) coding experience in SQL • 2+ years’ experience analyzing and develop Star Schema Designs, • 3+ years’ experience with MySQL, SQL Server Thanks and Regards *Tabish Abdin Khan* *Technical Recruiter* *IDC Technologies Inc.* *1851 McCarthy Boulevard, Suite 116|Milpitas, CA – 95035* *Ph: 408-668-9301* *Email: tabish.ab...@idctechnologies.com <tabish.ab...@idctechnologies.com> Website: www.idctechnologies.com <http://www.idctechnologies.com/>*-- *Please send me the resume-* *tabish.ab...@idctechnologies.com <tabish.ab...@idctechnologies.com>* -- You received this message because you are subscribed to the Google Groups "REQSRESUMES" group. To unsubscribe from this group and stop receiving emails from it, send an email to reqsresumes+unsubscr...@googlegroups.com. To post to this group, send email to reqsresumes@googlegroups.com. Visit this group at https://groups.google.com/group/reqsresumes. For more options, visit https://groups.google.com/d/optout.
