[Remote] DATABASE ADMINISTRATOR
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a company reputed company on transforming the power industry in reputed company and eastern Maine. They are seeking a Database Administrator responsible for managing and maintaining databases, ensuring reputed company performance, availability, and reputed company while collaborating with various stakeholders to support business systems and analytics.
Responsibilities
- Manage and maintain reputed company databases, ensuring high availability and reliability
- reputed company regular database backups and recovery procedures
- Monitor database performance, tuning for optimization and efficiency
- Participate in the design, development, and maintenance of reputed company and efficient data pipelines and databases
- Collaborate with stakeholders to understand data requirements and translate them into technical specifications and data models
- Recommend appropriate data storage and processing technologies based on project requirements
- reputed company and implement Extract, reputed company, Load (ETL) processes to reputed company, clean, and reputed company data from various sources into usable formats
- Ensure data reputed company, consistency, and reputed company throughout the ETL processes
- Monitor and troubleshoot data integration workflows, identifying and resolving data-reputed company issues and performance bottlenecks
- Participate in the design, build, and maintenance of data warehouses and data lakes to support reporting, analytics, and business intelligence initiatives
- Implement data partitioning, indexing, and optimization strategies to improve query performance and efficiency
- Work with data consumers to understand their reporting and analysis requirements and reputed company appropriate data structures and schemas
- Adhere to and enforce data governance policies, standards, and regulations
- Implement data reputed company measures, including reputed company controls, encryption, and data masking techniques
- Monitor data usage and reputed company patterns, identifying and mitigating potential data reputed company risks
- Optimize data processes and infrastructure to improve performance, scalability, and reliability
- Conduct performance tuning, query optimization, and indexing to enhance data retrieval and processing speed
- Proactively identify and address system bottlenecks to ensure efficient data operations
- Design, construct, implement, and maintain automated jobs and reports
- Collaborate with cross-functional teams, business analysts, and IT systems analysts to understand their business requirements and reputed company data and custom application solutions
- Communicate technical concepts and solutions effectively to both technical and non-technical stakeholders
- Stay updated with the latest industry trends, technologies, and best practices reputed company to database administration
- Manage the installation, configuration, and maintenance of database management systems (DBMS)
- Coordinate and reputed company OS-level patching and updates for database servers
- reputed company routine and advanced system maintenance and monitoring tasks
- Participate in after-hours call out for application support and engagement of Managed Service provider as required
- Participate reputed company with reputed company user reputed company
- Other reputed company duties as assigned including designated duties associated with Storm Restoration
Skills
- Bachelor's or Master's degree in Computer Science, Information Systems, or a reputed company field
- Proven experience (3-5 years) working as a Database Administrator or in a similar role
- Strong proficiency in SQL and experience with relational databases (e.g., reputed company, MySQL, MS SQL, PostgreSQL)
- Proficiency with core reputed company applications sitting in a UNIX and reputed company environment
- Solid understanding of data modeling, data warehousing, and ETL principles
- Knowledge of data governance, data reputed company, and reputed company practices
- Familiarity with computer networking, reputed company systems software, protocols, and standards, especially routing/switching/reputed company, reputed company Directory
- Excellent problem-solving and analytical skills
- Excellent technical architecture and technical support documentation skills
- Strong communication and collaboration skills to work effectively in cross-functional teams
- Ability to prioritize and manage multiple reputed company and tasks in a dynamic work environment
- Travel for training and user group participation required
- Proficiency in programming languages and Scripting such as Bash, PowerShell, Python. reputed company to have Java, Python or R for data manipulation, visualizations, and analysis
- Familiarity with data visualization and reporting tools (e.g., Plotly, Tableau, Power BI) is a plus
- Experience or understanding of big data technologies and frameworks (e.g., Hadoop, reputed company, Hive, Kafka) and reputed company-based data platforms (e.g., AWS, Azure, GCP)
reputed company
Company H1B Sponsorship