Add office photos
All Filters
4 Moonpreneur Jobs
Database Administrator
Moonpreneur
posted 2mon ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
We are looking for Database Administrator to join our database team having 8 + years of experience. In this role, you will be performing day-to-day database administrative task that includes design, database schema definition, database access privilege management, database query optimization, documentation, database instance patching and upgrades, long-range requirements, data encryption and database protection, SSRS and BI.
Responsibilities:
A. Robotics / Home Automation / Futuristic Trends Instructor:
- Review data within the database to ensure user data integrity, maintain database support tools, database tables and dictionaries, recovery and backup procedures, and make recommendations regarding enhancements and improvements.
- Install, configure, and manage multiple SQL server environments, to include Monitoring, Analysis and Reporting solutions.
- Extensive documentation of DBA procedures and work progress with respect to DevOps culture.
- Understand, write, and execute custom and third-party SQL scripts.
- Execute, manage, and validate database server backups leveraging forward thinking concepts, processes, and technology that meet the organizations Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
- Responsible for operational management and implementation of upgrades and enhancements of the database environment supporting multiple databases.
- Troubleshoot techniques and analysis with SQL Server service outages and performance issues as they occur in real time.
- Responsible for the lifecycle of SQL performing routine SQL patch updates, applicable service packs, and new major versions as they are released.
- Be available and flexible for part of on-call support rotation.
- Understand Windows clustering technology to support various SQL clusters and SQL Always On Availability Groups.
- Experience using SSRS to provide reporting capability to meet customer needs.
- Analyze data, including trend and pattern detection, using SQL and Excel.
- Develop analytics solutions that are scalable, repeatable, and effective.
- Develop appropriate data querying, manipulation, cleaning and processing code that may incorporate data from multiple sources (e.g. relational data, APIs, flat files).
- Collaborate effectively through brainstorming, planning, group development, and pair programming to meet the expectations of the team and stakeholders.
- Find simple, interpretable, solutions to complex data problems with attention to detail.
- Present work products clearly and effectively, using visualizations and storytelling.
- Document work both through readable self-documenting code, and through documentation in GitHub, and using version-control methodologies (e.g., Git).
- Assist in the development of Use Cases, Requirements Definition Documents, Detailed Design Specifications.
- Assist developers with SQL and MySQL development. Automate daily tasks.
- Other duties as assigned.
Skills:
- Bachelor s degree and minimum 6 years of database administration experience. Additional years of relevant experience may be considered in lieu of Bachelor s degree.
- Prior experience maintaining databases in a production environment
- Ability to create tables, tablespaces, triggers, views, stored procedures and other database objects
- Prior experience programming with different database languages.
- Deep knowledge of MySQL, Microsoft SQL Server 2016 thru SQL 2019 to include installation, configuration, upgrades, and maintenance of Microsoft database technologies.
- Experience with MySQL, MS SQL Server, data backups, data recovery, SSIS package and SQL stored procedure development and security fixes.
- Domain level technical knowledge to maintain databases, ensure recovery and provide patches on SQL databases, experience executing/monitoring production database backup operations.
- Experience working independently on technical database administration activities on SQL and MySQL databases.
- Experience implementing a broad range of assignments requiring originality and innovation in determining how to accomplish tasks.
- In-depth experience in performance tuning using instance and database level configuration, index and statistics maintenance, and fragmentation management
- Ability to work in a fast-paced team-oriented remote environment
Nice to have:
- Experience with cloud services (AWS, Microsoft Azure) a plus.
- Demonstrated Working knowledge of Linux, AWS, Azure, VMware vSphere (Virtualization Management), EMC Data Domain (Storage Management)
- Migration between instances and between on-prem to AWS and Azure environments
- Familiarity with Agile Framework DevOps and Zoho
- Automation using Microsoft PowerShell, VBScript, or batch files.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Database Admin roles with real interview advice
People are getting interviews at Moonpreneur through
People are getting interviews through
(based on 2 Moonpreneur interviews)
Campus Placement
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
What people at Moonpreneur are saying
What Moonpreneur employees are saying about work life
based on 61 employees
Flexible timing
Monday to Saturday
No travel
Night Shift
Moonpreneur Benefits
Team Outings 
Work From Home 
Education Assistance 
Soft Skill Training 
Job Training 
Compare Moonpreneur with
Flipkart
Compare
Paytm
Compare
Ola Cabs
Compare
Zomato
Compare
Swiggy
Compare
MakeMyTrip
Compare
PolicyBazaar
Compare
Nykaa
Compare
BigBasket
Compare
TCS
Compare
Accenture
Compare
Cognizant
Compare
Wipro
Compare
Capgemini
Compare
HDFC Bank
Compare
ICICI Bank
Compare
Infosys
Compare
HCLTech
Compare
Tech Mahindra
Compare
Genpact
Compare
Share an Interview