What are the responsibilities and job description for the SQL DBA position at PlaceMe?
Overview
Maintain, troubleshoot, install and develop enterprise level MS SQL database systems.
Qualifications
- Education: Degree in Computing
- At least 2 years DBA experience in a high transaction 24*7 environment, supporting both development and production databases within a busy business operation.
- Proficient at analysing Information
- Excellent SQL Server database administration & development skills including T-SQL and Stored Procedures.
- Deep knowledge and experience of replication, disaster recovery, high-availability clusters, backup etc.
- Software Design, Debugging, Documentation, Testing, Problem Solving, Teamwork, Development Fundamentals, Development Process and Requirements
- Excellent database design and analysis skills and data analysis experience.
- 1 years experience in a MS SQL Database Developer role with proficiency in writing T-SQL and Stored Procedures.
Responsibilities
- Provide day-to-day DBA operational support.
- Capacity planning, monitoring, auditing, database/application performance optimization.
- Proactively suggest/implement database and application patches, new releases and take role in future system design and direction.
- Installing and maintaining MS SQL servers running latest edition in an enterprise level production environment.
- Proactively improving/troubleshooting system performance.
- Planning backup and recovery of databases.
- Develops software solutions by studying information needs; conferring with users; studying systems flow, data usage, and
- work processes; investigating problem areas; following the software development lifecycle.
- Design, Develop, Test, Debug and deliver new products and features.
- Develop, update and apply procedures supporting company's data security and integrity policies and regulations.
- Design, develop and deploy reporting solutions.
- Configuring, deploying and maintaining database servers.
- Guide development team on efficient coding and best practices.
- Assist with effort estimates and project schedules.
- Enhance and maintain system functionality.
- Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, and code.
- Improves operations by conducting systems analysis; recommending changes in policies and procedures.
- Updates job knowledge by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
- Protects operations by keeping information confidential.
- Provides information by collecting, analysing, and summarizing development and service issues.
- Accomplishes engineering and organization mission by completing related results as needed.
- Cross train with and support IT administrator.
- Complete some analytics and report development.
Nice to Have:
- Knowledge of monitoring, optimizing, maintaining security controls, and troubleshooting cloud infrastructure (preferably AWS).
- Experience designing, implementing, and managing AWS-based infrastructure using infrastructure as code tools such as CloudFormation or Terraform.
- Tableau development experience.
- SQL Development experience.
