Job Descriptions:Provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Develops requirements from a project's inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts.
IT professional that oversees all aspects of a business database and applications. This would include anything from initial database architecture design through implementation, administration, monitoring, tuning, back up, migration and support and application support after development or integration from other departments or third parties.
Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, script and macros; updates existing queries, create new ones to manipulate data into a master file; and builds complex systems using queries tables, Open Database Connectivity and database storage and retrieval using cloud methodologies.
Data Reporting. Support Technical Operation Team in defining monitoring based on data and BI.
-MySQL and MSSQL database administrations (setup, performance tuning, monitoring).
-RDMS Database design
-TSQL and procedures development
-Data migration and prepare DB changes scripts
-Data Analyzing and building system health check and decision-making views
-Data presentation (Tableau is a plus)
-AWS Could computing (AWS EC2, S3, Redshift and RDS) Linux shell scripting