SQL DBA Data Modeller
- Appsierra Solutions
- 10 to 14 Yrs
- haryana
- 1 month ago
- Email to a friend
- Report this job
Job Description
- Technical Skills: 10+ years of experience on Database Management Systems, configures database parameters and prototype designs against logical data models. Defines data repository requirements, data dictionaries and warehousing requirements. To optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Experience/knowledge with Microsoft SQL Replication and CDC technology is must. Experience setting up and configuring HA (High Availability) / Replication/AlwaysOn. Preferably having researched and fine-tuned a setup so that the person understands what/why and can understand our needs and design/implement/configure a setup that meets client needs. Solid SQL Server DBA experience, in general. *The typical DBA skills / experience including DB maintenance, table/index/etc. maintenance, backups, monitoring, security, data dictionary, integrity checks, configuration, patching, and statistics, etc. Experience with SQL Server 2008/2012/2014/2016, preferably with multiple editions (Standard, Enterprise, etc.). Experience having installed and configured SQL Server instances in a similar capacity Thorough understanding of Performance Tuning both as a System DBA and Application DBA (difference being Application DBA is more about query/application performance tuning and System DBA is about tuning the database itself, how it is configured, etc.). Strong SQL skills Strong Data Modeling skills both Logical/Physical Database Modeling knowledge Strong analytical and problem solving skills Excellent verbal and written communication skills Strong experienced with Microsoft tools and software (Visual Studio 2012/2015, SQL Mgmt. Studio, Microsoft Office, etc.) Experience with Data Warehousing and OLTP database management. Measure, track and meet SLA metrics (analytics cycle time, schedule, accuracy, rework, etc.). Assist in database performance tuning and troubleshooting database issues in both OLTP and EDW environments. Install, configure, and maintain critical SQL Server databases. Dimensional and relational based databases. Supporting internal and customer facing applications Assist in the full range of SQL Server maintenance activities (for example): Backups, restores, recovery models, database shrink operations, DBCC commands, and Replication. Table, Index, etc. design, creation, and maintenance. On-going maintenance activities - working to plan and automate as much as possible. Increase availability and performance while at the same time reducing manual support time. Assist as part of the team designing, building, and maintaining the future state of Merchants database platforms: SQL Server versions, editions, and components. Database server configuration. Database and Data Model standards Business Continuity and High Availability strategy. Overall Data Architecture. Upgrade and Patching strategy. Knowledge in snowflakes, stored procedures is preferred. Knowledge in ETL Integration layer ,SSIS and SSRS. Installation and configuration of SSRS, SSIS and SSAS. Good to have Deep Azure experience Process Skills: General SDLC processes Understanding of utilizing Agile and Scrum software development methodologies Skill in gathering and documenting user requirements and writing technical specifications Behavioral Skills : Good Attitude and Quick learner Well-developed analytical & problem-solving skills Strong oral and written communication skills Excellent team player, able to work with virtual teams Excellent leadership skills with ability lead and guide and groom the team Self-motivated and capable of working independently with minimal management supervision Able to talk to client directly and report,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Not Specified
Functional Area: Not Specified
Role/Responsibilies: SQL DBA Data Modeller
Contact Details:
Company: AppsierraLocation(s): Haryana
Keyskills: High Availability Performance Tuning Data Modeling Analytical Skills Data Warehousing Troubleshooting Database Maintenance SQL Server DBA Verbal Written Communication Agile
Similar positions
Appsierra Solutions
AppSierra is an IT service provider of latest technology solutions that delivers measurable business outcomes to startup and mid-sized companies. Its offerings encompass strategic consulting, custom web & mobile development services, quality assurance and digital marketing services. AppSierra enable...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in