Database Administrator Developer
Resume:
*+ years of experience in Sqlserver, Oracle, Goldengate, Power Shell Script, shell script and Azure environments as a Senior DBA SME level on all these environments and Products, Performance tuning expert, Database Break fixing expert, Migration expert and PLSQL Database Developer.
Extensive experience in installation and configuration of MS SQL Server.
Worked extensive on Sqlserver P2P transactional replication active-active between DCs.
Worked and mentoring all the Sqlserver High Availability Always on, Cluster, Mirroring, Log shipping.
Expertise in planning and implementing MS SQL Server Security and Database permissions.
Sound knowledge in Database Backup, Restore and Disaster Recovery procedures.
Experienced with troubleshooting database problems.
Extensive knowledge in Relational Data Base Management System (RDBMS).
Experience in implementing different types of Replication types like Snapshot, Merge, P2P multi-dimensional and Transactional with immediate updatable subscribers.
Maintained Database Authentication modes, Creation of user, configuring permissions and assigning roles to users.
Experience in scheduling Alerts and Jobs.
Having worked and good knowledge of Clustering, Mirroring and Log shipping.
Good team player, strong interpersonal and Communication skills combined with self motivation, initiative and ability to think outside the box.
Worked closely with management, development teams and users.
Experienced in Creating Database Objects like Databases, Tables, Cluster/NonCluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.
Capacity management analysis and plan for the next year budget.
PCI and SOC audit for all projects give all necessary requests raised by them.
Planning, coordinating different teams and executing DC to DC database server migrations.
Database software licenses management and inform proactively to the management for upgrade.
Working with Monitoring team configuring alerts using BMC and Zabbix monitoring tools.
Working closely with Application team and OS teams.
24x7 on call handling with many applications and multiple databases.
Maintaining multiple projects database servers SLA with 99.9995.
SME on multiple database platforms Sqlserver, Oracle and Azure.
Maintained Database Authentication modes, Creation of user, configuring permissions and assigning roles to users.
Extensive experience in installing and managing Oracle 12c RAC servers.
Extensive working experience in Dataguard setup and managing
Extensive working experience in Shell scripting and crontab jobs.
OEM setup and monitoring oracle servers.
Experienced with Table design, Index design and Performance tuning.
Experience
Organization
Designation
Duration
Ford Motor Co. Dearborn, Michigan, USA
Senior Database Administrator
Apr 2015–Till Date
IBM India PVT. Ltd., Bangalore, India
Database Administrator
Aug 2013–Feb 2015
Education
Bachelor of Science in Computer Science and IT, Tribhuvan University, Nepal
Certification
Microsoft Certified for Database Administration.
OCP Certified
ITIL V3 Certified
#1 Ford Motor Co. Dearborn, Michigan
Environment:
Technologies
Tools:
Duration:
Role:
Responsibi-lities:
Windows 2003, 2008, 2012, 2014, 2016, 2019 server, Linux, IBM AIX, SUN Solaris.
Sqlserver 2019, Sqlserver 2017, Sqlserver 2016, Sqlserver 2014, Sqlserver 2012, SQL Server 2008 R2, Sqlserver 2005, Oracle 11g, Oracle 12c, Goldengate, Azure and shell script.
IGNITE, BMC, Zabbix, Golden Gate, Spotlight, Jira, Salesforce, GIT, Ansible, Teraform, Jenkins, Graphana, SSIS and SSRS.
Apr 2015 to till date
Senior Database Administrator [SME]
Working with Monitoring team configuring alerts using BMC and Zabbix monitoring tools.
Worked in Sqlserver 2005 to Sqlserver 2008 Migration, Sqlserver 2008 to Sqlserver 2012, Sqlserver 2012 to Sqlserver 2016, Sqlserver 2016 to Sqlserver 2019 and Sqlserver to Azure.
Worked in Database servers design and architecture for data center consolidation.
Worked in Datacenter Migration tasks to create new servers and setting up fresh servers.
Worked in Oracle 10g to Oracle 11g and Oracle 12c migrations and datacenter migrations.
Capacity planning and managing.
Purchasing Licenses and certificates and maintaining
Assigning tasks and work to the team members
Interacting with Project Management team for understanding customer requirements.
Involving discussions with customers when break fixes.
Internal team trainings and cross platform and application trainings.
Resolving issues in team and team building activities.
Preparing monthly database availability, major activity and number of change requests done reports to top management.
Last five years all databases maintaining SLA by 99.9999% to 99.9995%.
Evaluating for purchasing tools for monitoring DB performance.
Yearly DB audit reports collection working with Auditors and provide request evidences.
Installing Oracle RAC and managing Oracle 12c RAC
Managing Locks, Deadlocks and enable and disable Trace flags and identifying actual cause of issues.
Generating and Reading AWR reports for performance and other issues fixes.
Database Auditing for Sqlserver and Oracle servers.
Shell scripts for Crontab jobs.
Disaster Recovery drill for Sqlserver and Oracle customers.
Datagaurd setup and fixing broken datagaurd.
Install Oracle and Sqlserver Softwares and setup new servers for datacenter migration.
Fixing lot of Performance issues on Sqlserver PRM hybrid application TDCT servers.
Goldengate replication application setup and managing GG replication.
Sqlserver P2P Replication for large transaction tables.
Sqlserver Logshipping setup and managing.
Sqlserver Mirroring setup and managing.
Sqlserver Clustering setup and managing.
Sqlserver Replication setup and managing.
Create Partition tables and managing weekly and Daily partition tables and related procedures and jobs.
Giving training for other new team members for DB servers applications
Giving Sqlserver training to other team members
Maintaining the jobs Scheduled during the night for the Backup of Databases.
Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
Enforcing business rules with triggers and user defined functions, troubleshooting, and replication.
Managing security, monitor server performance and activities.
Managing databases, tables, indexes, views, stored procedures.
Managing Licensing and disk spaces Oracle and Sqlserver environments
Creating new monitoring jobs and new standards for without any server failures.
Maintenance and Correction of Transact Sequel Server (T-SQL) Statements.
Daily Monitoring of the Database Performance and network issues.
Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
#2 IBM India Pvt. Ltd., Bangalore Aug 2013 to Feb 2015
Environment:
Technologies:
Role:
Responsibi-lities
Windows 2000, 2005 and Linux
Sqlserver 2000 and 2005, Oracle 10g and PL/SQL
Database Administrator
Sqlserver Logshipping setup and managing.
Sqlserver Mirroring setup and managing.
Sqlserver Clustering setup and managing.
Sqlserver Replication setup and managing.
Create Partition tables and managing weekly and Daily partition tables and related procedures and jobs.
Giving training for other new team members for DB servers applications
Giving Sqlserver training to other team members
Maintaining the jobs Scheduled during the night for the Backup of Databases.
Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
Enforcing business rules with triggers and user defined functions, troubleshooting, and replication.
Managing Licensing and disk spaces Oracle and Sqlserver environments
Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
Managing security, monitor server performance and activities.
Managing databases, tables, indexes, views, stored procedures.
Database design and data modeling using EA
Enforcing business rules with triggers and user defined functions and troubleshooting.
Performance and stress testing before go-live.
Detailed database design based on the requirement.
Writing the Stored Procedures, checking the code for efficiency.
Maintenance and Correction of plsql and sql Statements.
Tuning Sql queries to bring optimum performance.
Daily Monitoring of the Database Performance.
Administering to create user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
Contact this candidate