Vacancy expired!
Senior SQL Database Engineer Job Description
Duties and Responsibilities:- Administrate and integrate with Microsoft SQL Server so decent MSFT SQL DBA skill is required
- Demonstrate extensive knowledge of all aspects AWS Database Engines (RDS, DynamoDB)
- Include DB technology evaluation, guidance and consultation, design support, task automation and scripting, best practice and standards development, capacity planning, optimization and tuning, system upgrades and migrations, performance management, monitoring, security, backup and recovery, issue troubleshooting, and documentation.
- Implement and Maintain Automated Processes using TSQL/PowerShell/Python/Terraform scripts.
- Deploy, configure, monitor, and maintain databases in the production, development, and quality assurance environments.
- Understand AWS-based architecture and closely work with DevOps, SecOps develop scripts to support continuous deployment process and maintain the environment via TFS/Terraform.
- Work with Operations & Development team planning server/server-less resource requirements to decide the proper size for specific application requirements and performance metrics.
- Process database change requests, including the creation and modification of databases, tables, views, stored procedures, triggers, jobs, etc. in accordance with change control policies.
- Analyze problems, anticipate future problem areas, and implement solutions.
- Work outside of normal business hours as required for completing projects, working on deployments, and resolving system outages.
- Responsible for level 2 systems management and exercises project-level control over initiatives.
- Recommend and implement solutions for performance monitoring and tuning.
- Carries out assignments with minimal coaching and guidance from others.
- Develops, enhances, and adheres to engineering and administration standards. Upholds and maintains strong documentation.
- To be placed on on-call rotation for a week every 3 months and respond to system alerts
- Mid to high-Level Microsoft SQL Server DBA Skill is required
- Experience with at least one of the Pubic Cloud providers like AWS, Google Cloud Services.
- Knowledge of Relational Database Management experience such as MS SQL, PostgreSQL, MySQL, Redshift is preferred.
- Excellent technical expertise in relevant state-of-the-art data technologies, database warehouse data security, data systems, and its design. Able to formulate and present various solutions for business initiatives and discuss pros/cons for each option.
- Strong AWS experience
- Knowledge of monitoring tools such as Kibana, CloudWatch, DataDog, or any other tools, etc
- Knowledge of automation and deployment tools & Scripts: MS Team Foundation Service, ELK, PRTG, Jenkins, Chef, Lamda, Terraform, Cloudfomation, etc
- Experience with the implementation and support of SQL database replication.
- Experience working with very large databases, upgrades, and troubleshooting performance, etc.
- Experience with SQL Server High Availability Architecture (AlwaysOn) and troubleshooting.
- Degree in computer science/information systems, engineering, or related field preferred; or a corresponding number of years' experience in technical operations or software engineering
- 1-3 years of supporting a large data platform and data pipe-lining.
- 2-3 or more years of experience with NoSQL data platforms like Spark, Solr, MongoDB Atlas, DynamoDB.
- 2-3 years experience with relevant scripting languages or programming frameworks desired (PowerShell, Python, NodeJS, JavaScript, bash)
- Experience with Data Warehouse technologies such as AWS Redshift, Snowflake, Azure Data Warehouse, etc is a big plus.
- Expertise in database administration for large Data warehouse/datamart implementations including configuration, implementation, data modeling, maintenance, redundancy/HA/DR, security, troubleshooting/performance tuning, upgrades, database, data and server migrations, SQL
- Cloud migration experience
- Strong experience with Linux Server platform
- Experience solving data engineering problems using technologies such as Spark, Solr.
- NoSQL database experience (MongoDB/Hadoop/Redis/DynamoDB/Elastic Search).
- Strong Cloud Database management experience (Redshift/Snowflake) Data warehouse or Data analytics
- Knowledge of all aspects of Azure Database Engines (Managed Instances, Data Warehouse) including administration
- Programming skills are valuable such as .Net.
- AWS solution architect certification preferred
- Azure solutions architect associate certification is nice to have
- Comprehensive healthcare coverage: Medical / Vision / Dental / Prescription Drug
- Life, legal, and supplementary insurance
- Commuter and parking benefits
- 401(K) retirement plan with matching contributions
- Employee stock purchase plan
- Paid time off
- Tuition reimbursement
- On-site fitness center and/or reimbursed fitness center membership costs (location dependent), with yoga studio, Pelotons, personal training, group exercise classes, as well as Segways and bikes available for use during the day
- Complimentary gourmet coffee, tea, hot chocolate, prepared foods, fresh fruit, and other healthy snacks
- The CoStar Group website and RecruitiFi .
- Via email to/from addresses using only the CoStar domain of "@Costar.com."
- Screening and interaction by telephone and through the Microsoft Teams or Zoom platforms.
- CoStar does not use Wire, Google Hangouts, or any other platform for any recruitment-related activities.
- Disregard any solicitation or request for information related to job applications with CoStar via any other means and/or using email addresses with any other domain.
- CoStar will never ask candidates to make any type of personal financial investment related to gaining employment with the company.
Vacancy expired!