Database Administrator

Purple DriveWe are seeking an experienced Database Administrator to manage and maintain database systems, ensuring optimal performance, security, and availability. This role requires hands-on expertise in database monitoring, troubleshooting, and administration tasks.Database Monitoring & PerformanceMonitor database uptime, performance, space usage, and error logsRespond to alerts from monitoring tools and automated systemsTrack system performance metrics and identify potential issuesGenerate performance reports and capacity planning recommendationsTroubleshooting & Issue ResolutionTroubleshoot issues including slow queries, blocking, failed jobs, and connection problemsPerform root cause analysis for database incidents and performance issuesProvide permanent fixes for recurring problemsDocument troubleshooting procedures and solutionsUser & Security ManagementCreate and modify user accounts and permissionsImplement database security policies and access controlsManage authentication and authorization systemsConduct security audits and compliance reviewsBackup & RecoveryExecute backup and recovery actions according to established proceduresTest backup integrity and recovery processesMaintain disaster recovery documentation and proceduresCoordinate disaster recovery testing and failover proceduresDatabase Maintenance & OptimizationHands-on experience in disaster recovery and performance tuningManage patch and upgrade management processesPerform database maintenance tasks and optimizationPlan and execute database upgrades and migrationsInstance & Resource ManagementManage database instances, databases, buffer pools, and tablespacesConfigure and optimize database parameters and settingsMonitor and manage storage allocation and utilizationImplement capacity planning and resource optimization strategiesQualificationsRequired Experience5+ years of hands-on database administration experienceStrong background in database performance monitoring and tuningExtensive experience with backup, recovery, and disaster recovery proceduresProven expertise in troubleshooting complex database issuesTechnical SkillsDatabase Platforms: Experience with major database systems (Oracle, SQL Server, MySQL, PostgreSQL)Monitoring Tools: Proficiency with database monitoring and alerting systemsPerformance Tuning: Query optimization, index management, execution plan analysisSecurity Management: User access control, authentication, encryption, audit loggingBackup & Recovery: Backup strategies, point-in-time recovery, disaster recovery planningSystem Administration: Server management, storage systems, network connectivityRequired ExpertiseDatabase instance configuration and managementBuffer pool and memory management optimizationTablespace design and managementPatch management and upgrade proceduresSQL query analysis and optimizationDatabase security best practicesDisaster recovery planning and execution