database analyst (DBA)

Résumé du poste

The role involves designing, developing, and maintaining computer databases while implementing strategic blueprints for deployment. Responsibilities include writing scripts for stored procedures, ensuring data security, and documenting reporting needs and requirements.

Détails du poste

Overview Languages English Education Bachelor's degree Experience 2 years to less than 3 years On site Work must be completed at the physical location. There is no option to work remotely. Responsibilities Tasks Collect data to identify areas for improvement within an organization’s IT infrastructure Data Science Develop and implement a strategic blueprint to follow when deploying databases within their organization Develop and maintain computer databases Document customers’ requirements for projects Document reporting needs, queries, logic, results and recommendations to other information systems professionals Enact measures to make sure unauthorized users cannot access the data Liaise with staff on data requirements, collection and availability Provide advice to other informatics professionals regarding database management tools Setup the IT infrastructure to allow applications to access databases Test data models and database management systems Design and develop database Operate database management systems to analyze data Develop and implement data administration policy, standards and models Research and document data requirements, data collection and administration policy, and data access rules Write scripts related to stored procedures and triggers Experience and specialization Computer and technology knowledge Excel Visual Basic for Applications (VBA) Machine Learning Microsoft Visual Studio Data Warehouse Internet Desktop applications File management software Multimedia software Word processing software Presentation software Mail server software Communication software Programming software Mapping and data visualization software Database software Programming languages Enterprise resource planning (ERP) software Data analysis software MS Office MS Windows Spreadsheet Big data Python SQL Business intelligence Electronic mail Area of specialization E-commerce Additional information Work conditions and physical capabilities Work under pressure Attention to detail Sitting Personal suitability Accurate Client focus Efficient interpersonal skills Excellent oral communication Excellent written communication Initiative Judgement Organized Team player Adaptability Accountability Quick learner Benefits Health benefits Dental plan Disability benefits Health care plan Paramedical services coverage Vision care benefits Financial benefits Bonus Life insurance Other Benefits Free parking available

Ce que vous ferez

The role involves designing, developing, and maintaining computer databases while implementing strategic blueprints for deployment. Responsibilities include writing scripts for stored procedures, ensuring data security, and documenting reporting needs and requirements.

Exigences

Candidates must have a bachelor's degree and between 2 to 3 years of experience. Proficiency in SQL, Python, and various database management tools is required.

Avantages

• Health Benefits • Dental Plan • Disability Benefits • Health Care Plan • Paramedical Services Coverage • Vision Care Benefits • Financial Benefits • Bonus • Life Insurance • Free Parking

Compétences indiquées

• SQL · Souhaitée
• triggers · Souhaitée
• Analyse de données · Souhaitée
• Microsoft Excel · Souhaitée
• Apprentissage automatique · Souhaitée
• Python · Souhaitée

Autres compétences pertinentes

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• SQL
• Python
• Database Management
• Data Analysis
• Machine Learning
• VBA
• Data Warehousing
• Business Intelligence
• ERP Software
• Stored Procedures
• Triggers
• Data Modeling
• Microsoft Visual Studio
• Excel
• Big Data
• E-commerce

Domaines d’emploi

• Data & Analytics
• Technology
• Software
• Manufacturing