Manager Databases & Infrastructure
DPL Limited
Total years of experience :22 years, 0 Months
• Take care of SEM(Search Engine Marketing) overall architecture for the US client www.autobytel.com
• Delivering database architect role to establish database design/architecture, server/database high availability flavoring, data modeling, patch and hotfix implementations on live environments. Preparing planning documentation and technical diagrams to assign work to technical.
• Taking care of the underlying infrastructure of the database servers to meet the performance metrics of front end applications and design work for infrastructure capacity planning for the database servers.
• Execute tests, collect and analyze data, identify trends and insights in order to achieve maximum ROI in paid search campaigns.
• User data consolidation in central repositories for business intelligence systems.
• Track, report, and analyze website analytics and PPC initiatives and campaigns.
• Manage campaign expenses, staying on budget, estimating monthly costs and reconciling discrepancies.
• Develops specific goals and plans to prioritize, organize, and accomplish work to meet the requirements committed with onsite clients.
• Performs an assessment of needs, ensuring compliance with brand specific standards, budget and capital requirements.
• Determines priorities, schedules, plans and necessary resources to ensure completion of projects on schedule and according to specification.
• Ensures problems are correctly reported, routed, tracked and solved, with the system user being informed of situation at all times.
• Ensures proper asset management.
• Performs on-site monitoring of all projects and posting the status to senior management regarding the progress of projects.
• Ensures that regular on-going communication is happening in all areas of responsibility to create awareness of business objectives and communicates expectations, recognizes performance and produces desired business results.
• Maintaining information systems and technology goals.
• Engaging client teams in platform demonstrations and trainings.
• Preparing and sharing write offs, sign off with client management teams for final execution of the project plans.
• Ensuring the deployment releases/rollbacks performed on live applications within timelines. Arranging downtimes for critical upgrades/patching and cross scale testing after the activity completed to ensure all the functionality is intact.
• Managing routine operations to be completed and ensuring no SLA’s are missed. Proper escalations to the target teams to perform appropriate steps to avoid business productivity and revenue loss.
• Influencing, engaging and encouraging team members, at all level, to share inputs to achieve tasks with beneficial approach as per the technical functionality available in tools.
• Executing resource requirements, evaluation reviews, performance area and compliance of the tasks.
• 24/7 support for the SQL Servers Performance and scheduled critical operations for SQL servers 2008, 2008 Express, 2008 R2, 2005 and 2012 versions.
• Proactive study for new features and tools to achieve the business rules automation.
• Managing the High Availability/Disaster Recovery of SQL Servers, using Clustered instances, Always On Availability Groups, Mirroring, Log shipping and Replication, backup/restore.
• Update Patching/Service Packs, CU’s on servers and managing the services reboot
• Database migrations and SQL Server version/edition upgrades using inplace and side by side strategies.
• SQL Server, SSIS, SSRS, SSAS services, implementation, configuration, troubleshooting and administration.
• Managing the growth and capacity planning of the databases.
• Designing the capacity planning rules and automating the SQL Server health checks on daily/monthly basis.
• Implementing the change data capture (CDC)technology to achieve the historical data retention as per Business Audit rules.
• Ensure data quality, data standard and data integrity,
• Responsible for constructing triggers, tables, user functions, views, indexes, user profiles
• Implementing the Central Management Server (CMS) to generate central reports for various groups of servers and a centralized administration.
• Datawarehous ETL using SSIS packages and Reports development/deployment using SSRS service utilities at fundamental level.
• Managing the database filegroups, datafiles, logfiles to optimize the database performance and achieve the capacity planning measures. Reclaiming free space and log file vlf administration.
• Taking care of relocation of system and user database data and log files as per requirement
• Designing, implementing the backup and recovery plans/strategies of production and non-production servers for System as well as user databases
• Implementing the authentication/authorization security matrix for different environments using Database user defined roles.
• Configuring database mail profiles, Alerts, and proxy accounts for SSIS packages executions.
• Creating, troubleshooting, maintenance plans for various server activities
• Coordinating/working with the development teams and release management teams to implement the required physical and logical design of the database
• Handling configuration for SQL services account, proxy accounts, mail operators, users, roles management for various server environments & Create Linked Servers to
• Automating various database operations by coding T-SQL scripts and implement in SQL Agent jobs
• Routine deployments and code executions for database object’s updates.
• Proactive objects fragmentation administration to achieve the performance benchmarks
• Managing the Day to Day performance issues of SQL Server on production environments
• Taking care of the whole SDLC servers (Development, Test, UAT, Production, Production Reporting)
• Delivering training sessions to different teams in the company and client people national and international.
• Installation, configuration, upgrading and administration/maintenance of Microsoft SQL Server and related products. Additionally, setting up test, development, staging and production environment.
• Designing, establish and maintain sound backup and recovery policies and procedures. Automating SQL agent jobs maintenance plans and using alerts to carryout checks on databases.
• Periodic DBCC commands execution for necessary activities.
• Take care of the Database design and implementation.
• Implementing the health checks for database servers for Disk I/O activity, CPU usage, memory contention
• Setup and maintain documentation and standards.
• Served as DBA or project lead in the completion of small to medium-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
• Responsible for the ongoing redesign, management, enhancement, integration, consolidation, training, support and upgrade of database systems using best database practices and standards
• Creation of database users, roles, indexes, synonyms, materialized views, sequences objects for test, training and production databases.
• Execution of application update patches, scripts forwarded by the central office, back-end stored procedures, triggers and rules and validating procedures, packages, functions etc. after database updating process
• Storage management for test, training and production purpose database objects, tablespaces, relocation of data files, management of back-end stored procedures, triggers, rules, tables, views, privileges, roles, and indexes.
• Installation of oracle cluster ware and configure oracle data guard and oracle real application cluster (RAC) and achieve high availability.
• Prepare functional specifications and requirements to move applications into production and Work with Data Architect and Software Engineer to deploy and integrate business applications solution
• Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
• Convert required data from different databases through making scripts and using Import / Export, SQL Loader, SQL Developer.
• Preparing reports involved in recovery of amounts in millions, performing reconciliation of collections of collections on daily, monthly & yearly basis, generating notices for shortcomings in tax documents.
• Installation and configuration of oracle database server on server machines IBM Netfinity
• Installation of oracle forms and client application configuration with server side database
• Installation of SQL Developer, Toad for oracle to access database objects for data retrieval for reports and further function performing on variety of database objects like validation, refreshing, managing user sessions
• Assistance in creation of database, database objects like tables, views, indexes, sequences, materialized views, along with senior DBA and DB Team
• Creating database users using scripts, provided by the senior DBA
• Optimization of sql queries using stored procedures
• Managing oracle tablespaces locations on different disks to optimize the storage for oracle objects
• Configuring the client server application using oracle net easy config utility
• Managing the oracle network files tnsnames.ora, sqlnet.ora, listener.ora and oracle services
• Managing the daily oracle backups using RMAN utility provided by oracle
• Managing the weekly cold backups of database
• Preparing reports as per demands of the management, marketing and sales staff
• Performing business analysis using the data of production database
passed the F.Sc. with 1st division
passed the matric Exam with 1st division