Objective to manage the design and architecting of Data Management, Schemas, Data collection, consolidation,correlation, classification, labeling, mining,modeling, clustering of different Data sources within the company, Partners,sensors and public domain into company Data Lake, in order to serve larger purpose of Data collection, processing,Population, Analysis Reports, segmentation and Sales reports, External ETL data systems, to achieve organizational goals of structured & unstructured data, SQL and Non-SQL Data along with Object base Data).
Having an experience in Apache Kafka, Distributed Data Architecture deployment, from design to implementation, is a plus.
Design and implement effective database solutions and models to store and retrieve company data.
Examine and identify database structural necessities by evaluating client operations and applications.
Assess database implementation procedures, build schemas, and ensure they comply with internal and external regional data privacy, data safety and data protection regulations.
Prepare accurate database design and architecture reports for ETL, BI reports and executive teams.
Oversee the migration of data from legacy systems to new distributed and decentralized solutions.
Monitor system performance by performing regular tests, troubleshooting, and integrating new features.
Install and organize information monitoring systems to guarantee company functionality.
Recommend solutions to improve new and existing database systems.
Educate Developers and staff members through training and individual support.
Offer support by responding to system problems in a timely manner.
To Install and maintain the performance of database servers.
Prepare and configure High Availability and Cluster mode for Database.
Strong command of SQL and SQL server tools
Develop processes and Queries for optimizing database security.
Set and maintain database standards with DB Hardening Process.
Monitoring drive space, database space, Log file space
Monitoring SQL server logs and windows logs
Manage database access, User Matrix , Privileges.
Database security, backup and recovery, and performance monitoring.
Maintenance, indexing , periodic tuning of database systems.
Ensure high levels of performance, availability, sustainability and security.
Understanding of relational and dimensional data modeling.
PowerShell and Unix shell scripting skills.
Extensive experience with other database technologies (MySQL, MS SQL, PostgreSQL, MongoDB).
Install, upgrade, and manage database applications.
Analyze, resolve issues in real time.
Diagnose and troubleshoot database errors, deadlocks.
Assist developers with query tuning and schema refinement.
Create and manage database reports, Auditing, visualizations, and dashboards.
Database Mirroring configurations and Real time Disaster Recovery procedures on DR Site.
Create automation and scripts for repeated tasks.
Supporting 24*7 production support to the organization and on-call support whenever required.
Screening Criteria:
Immediate joiners
Min 4 to 7 years of Experience
location: Remote
Qualifications:
Bachelor or Master Science in computer science, computer engineering, or a related field.
Primary Skills:
Should be able to design a full database Architecture from scratch that supports highly available Database schemas.
More than creating or handling database, should build a platform of databases that will be supported and responsible to handle kubernets and non kubernets platform or requests.
Focus on infrastructure Architect [IA] including Virtual machines,Kubernets,interactions based on different components.
Specific technology and tools: Data modeling and Replication.
Secondary Skills:
Experience with a variety of database technologies such as Apache Kafka, MySQL, MongoDB, and HADOOP, CASSANDRA operating in large scale environments.
Write scripts and utilities to monitor, manage, and maintain databases. Experience with scripting; PHP, python, JavaScript or bash programming.
Experience with data access and ETL Layer.
Must have skills:Data Management Architecture, Apache Kafka, Database Engineering or Database Administration.
Hands on Tools such as:Dash and plotly, Kafka Stream, power bi, Qlickview, airflow, Postgres , mssql and Hive, HDFS , hive , sqoop , zeppline, spark, Sqoop, oozie & Spark.
