Job Description
Job Summary:
The Database Administrator assists with development and maintenance of SQL databases and development of business intelligence applications, DBA responsibility including data modeling, performance, integrity and security of database, also troubleshooting user issues, user access data concurrently, and database backup/restore planning. This role is critical to ensuring the integrity, availability, and security of our data, and to supporting our advanced data analytics and machine learning initiatives.
Essential Duties and Responsibilities:
• Design, implement, and maintain robust database architectures that meet business requirements.
• Develop and implement processes for cleaning, organizing, and transforming data from various sources
• Identify and rectify data quality issues, including duplicates, missing values, and inconsistencies
• Install, configure, and maintain Microsoft SQL Server databases
• Ensure high availability, disaster recovery, and security of databases
• Optimize database performance through regular monitoring, tuning, and maintenance activities
• Manage database security, including user access and permissions
• Develop and implement automated processes for data extraction, transformation, and loading (ETL)
• Create scripts and tools to automate routine database maintenance tasks
• Continuously evaluate and improve database management processes to increase efficiency
• Work closely with cross-functional teams, including Research, IT, and software development
• Refine the logical design so that it can be translated into a specific data model
• Maintain data standards, including adherence to the Data Protection Act, HIPAA
• Write database documentation, including data standards, procedures, and definitions
Qualifications and Requirements:
• Bachelor’s degree in Computer Science, Computer Engineering, or Mathematics
• Master’s degree in a related field a plus
• Certifications in database management or related technologies a plus
Knowledge and Skills and abilities:
• Strong proficiency in SQL and experience with major database systems (e.g., SQL Server, MySQL, PostgreSQL).
• Problem-solving and good analytical skills
• Proven experience as a Database Administrator with a focus on data cleanup, transformation, architecture, and automation.
• Experience with ETL tools and processes.
• Familiarity with machine learning concepts and tools (e.g., Python, R, TensorFlow, scikit-learn)
• Knowledge of data warehousing and big data technologies
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Excellent verbal and written communication skills
• Experience with cloud database solutions (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL) is a plus
...An innovative and local artistic hair salon is seeking a thorough and motivated Salon Administrative Assistant to join their team! They're seeking someone with retail, customer service, and/or administrative experience. If you are creative and seeking a long-term fit...
...Working Title: Air Compliance Inspector Job Class: Environmental Specialist 1 or 2 Agency: Pollution Control Agency Job ID : 81514... ...sponsor applicants for work visas. In compliance with federal law, all persons hired will be required to verify identity and eligibility...
...treatment plant equipment for a soybean crushing and biodiesel plant. Primary function is the testing and monitoring of wastewater and boiler processes to ensure they are operated and controlled in a safe and efficient manner in compliance with government regulations and...
Corporate M&A and Private Equity Associate Company nameBCG Attorney SearchExperience2-13 yrs requiredLocationMiami, FL, United StatesPosted onNov 20, 2024Valid ThroughDec 20, 2024ProfileA law firm seeks a driven Corporate M&A and Private Equity Associate to...
**Job Description:****Position Overview:** DHL is hiring Seasonal Package Delivery Drivers to help manage the increased package volume during the holiday season. This position is ideal for those who enjoy working independently and have a passion for delivering excellent...