hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

SQL Data Base Administrator

5.00 to 10.00 Years   Pune   02 Dec, 2024
Sakshi Consultancy Services
Job LocationPune
EducationNot Mentioned
SalaryRs 2.0 - 5 Lakh/Yr
IndustryIT Services & Consulting
Functional AreaApplication Programming / MaintenanceClient Server
EmploymentTypeFull-time

Job Description

    Position :SQL Data Base AdministratorLocation : Baner , PuneMinimum 4-5 Years of experience required and immediate JoinersRoles and Responsibility :1. Database Design and Architecture: Design and optimize database schemas for sales, service, spares, accounting, and other DMS modules. Ensure data integrity and normalization while supporting application performance needs.2. Performance Tuning: Monitor and optimize query performance, indexing, and storage utilization. Identify and resolve database bottlenecks to support high transaction volumes.3. Data Maintenance: Manage backups, restores, and disaster recovery plans to ensure data availability. Implement data archiving and partitioning strategies for large datasets.4. Collaboration: Work closely with developers, tech leads, and architects to support application requirements. Assist in designing efficient APIs and data workflows.5. Cloud Readiness and Migration: Plan and execute database migration to the cloud (production only), ensuring minimal downtime and data consistency.Implement hybrid strategies for on-prem staging and development environments.6. Security and Compliance: Ensure databases comply with data security standards and implement role-based access control (RBAC). Monitor and manage vulnerabilities, encryption, and audit trails.7. Monitoring and Troubleshooting: Set up monitoring tools for real-time insights into database health and performance. Troubleshoot and resolve database-related issues promptly.8. Process and Documentation: Establish and document standard operating procedures for database management. Create and maintain comprehensive database documentation, including schemas and workflows.Skill Set RequiredMin 5 years of hands-on-experience as mentioned in the Role andResponsibility and Skill SetDatabase Systems: MSSQL, PostgreSQL, NoSQL, Azure SQL Database Query Optimization: Proficient in SQL query tuning, indexing strategies, and execution plans. Knowledge of SQL Server Analysis Services (SSAS) Programming: PowerShell scripting Database Design: Experience in schema design, normalization, andpartitioning.Backup and Recovery: Expertise in backup strategies, replication, and disaster recovery setups.Performance Monitoring: Familiarity with monitoring tools like Oracle Enterprise Manager, SolarWinds, or Nagios.Cloud Databases: Experience with AWS RDS, Azure SQL Database, or equivalent platforms.Security: Knowledge of encryption, RBAC, and database security best practices.Tools and Technologies:ETL Tools: Experience with data migration and transformation tools (e.g., Talend, Informatica).Scripting: Proficiency in scripting languages like Shell, Python, or Perl for automation.DevOps Integration: Basic understanding of CI/CD pipelines and database versioning tools (Flyway, Liquibase).Visual StudioCertifications Microsoft Certified: Azure Database Administrator Associate preferred ITILfoundation certification

Keyskills :
sqldatabasedbsdatabase

APPLY NOW

SQL Data Base Administrator Related Jobs

© 2019 Hireejobs All Rights Reserved