| Database analyst at Tallahassee, Florida, USA |
| Email: [email protected] |
| From: sreekanth, 3ktechnologies [email protected] Reply to: [email protected] Hi ALL, Job Title: Database analyst Location: Tallahassee, FL(From Dayone onsite) Duration: Long Term Description: A bachelor's degree from an accredited college or university in management information systems or in one of the computer sciences and three (3) years of experience in Database Administration, DBMS design and support or relevant computing environments. 5.2.3.1 The Database Analyst must have knowledge and experience in the following areas related to database languages and integration: a. Database Management Systems (DBMS): Familiarity with popular DBMS platforms such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL. Understanding the concepts of data modeling, table structures, and query optimization. b. Structured Query Language (SQL): Proficiency in SQL, including writing complex queries, optimizing database performance, and manipulating data using SQL statements. Understanding of joins, subqueries, and indexing. c. Data Integration Tools and Techniques: Knowledge of data integration methods and tools, such as ETL (Extract, Transform, Load) processes, data migration strategies, and data synchronization techniques. Familiarity with tools like Informatica, Talend, or SSIS (SQL Server Integration Services). d. API Integration: Understanding of API (Application Programming Interface) concepts and experience with integrating systems using APIs. Knowledge of RESTful APIs, SOAP, or other web service protocols. Ability to work with API documentation and make API calls for data retrieval or data synchronization purposes. e. Data Mapping and Transformation: Proficiency in data mapping techniques to align data structures and fields between different systems. Experience in data transformation processes to convert data formats, standardize data, or cleanse data during integration. f. Data Warehousing Concepts: Understanding of data warehousing principles and practices. Knowledge of dimensional modeling, ETL processes for data warehouse loading, and data mart design. Familiarity with tools like Snowflake, Amazon Redshift, or Microsoft Azure Synapse Analytics. g. Data Governance and Data Quality: Awareness of data governance principles, including data standards, data quality rules, and data lineage. Understanding the importance of data integrity, data validation, and data cleansing techniques during integration. h. Database Performance Optimization: Knowledge of techniques for optimizing database performance, including query optimization, indexing strategies, and database tuning. Ability to identify and resolve performance bottlenecks in integrated systems. i. Data Security and Privacy: Understanding of data security principles and best practices, including data encryption, access controls, and data privacy regulations (e.g., GDPR, HIPAA). Knowledge of secure data handling during integration processes. j. Data Analysis and Reporting: Proficiency in data analysis tools and techniques to extract insights from integrated datasets. Experience in creating reports, dashboards, or visualizations to present integrated data to stakeholders. Thanks Sreekanth. Technical Recruiter 3K Technologies, LLC www.3ktechnologies.com [email protected] Keywords: Florida Database analyst [email protected] |
| [email protected] View all |
| Thu Aug 29 20:10:00 UTC 2024 |